Example Database Connections for Microsoft SQL Server

Note:  Example values and screens given in this section are based on particular database and driver software versions and configurations.  They are provided for illustration and guidance.  Your own environment may require different values and procedures.

 

You may need to establish two types of connectivity to your Microsoft SQL Server database for use with the mapping tool and the maps it generates:

• ADO or ODBC (or JDBC) connection from the LANSA Composer client computer

     While defining your map you need to be able to establish an ADO or ODBC connection to the Microsoft SQL Server database on your network.  This connection is initiated from the client computer running MapForce. Refer to:

Adding a Microsoft SQL Server database component in MapForce using ADO

• JDBC connection from the LANSA Composer server computer

     When the Transformation map (prepared as Java executable file) runs, it will use a JDBC connection to establish the connection to the Microsoft SQL Server database on your network.  This connection is initiated from the server computer on which the transformation map executes and is defined in LANSA Composer by means of a Database Configuration. Refer to:

Defining the database configuration for Microsoft SQL Server

Refer also to:

Additional information and resources for Microsoft SQL Server