Defining the database configuration for Microsoft SQL Server

When the Transformation map (prepared as Java executable file) runs, it will use JDBC 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.

LANSA Composer prepares the JDBC connection according to the Database Configuration that you provide as a parameter to the Transformation Map. You must define the Database Configuration with the correct details necessary to establish the particular database connection to be used.

Example Database Configuration

The following sample values assume that you are using Microsoft's JDBC driver to connect to the Microsoft SQL Server database on your network:

Database driver class

Following are class names commonly used with the Microsoft SQL Server JDBC drivers: For Microsoft SQL Server 2005 and later: com.microsoft.sqlserver.jdbc.SQLServerDriver For Microsoft SQL Server 2000: com.microsoft.jdbc.sqlserver.SQLServerDriver

Database connection string

Following is a sample JDBC connection string to connect to the Microsoft SQL Server database named TUTORIAL running in the SQL Server instance named SQLSERVER on the server named TEST0101 (note the direction of the slashes IS important): jdbc:sqlserver://TEST0101\SQLSERVER;databasename=TUTORIAL;integratedSecurity=true; Note that a default port number will be assumed if you do not specify one.  If necessary (for example, if your installation of SQL Server is listening on a different port number) you may specify the port number in the connection string as follows: jdbc:sqlserver://TEST0101\SQLSERVER:1433;databasename=TUTORIAL;integratedSecurity=true; (But please refer to the note below concerning the use of the port number in the connection string.)

 

Further considerations

• The Database Configuration should specify the username and password of the Windows or SQL Server user authorized to perform the database transactions, unless you are using integrated Windows authentication, in which case the user name and password should be empty.

 

Refer also to:

Additional information and resources for Microsoft SQL Server