Connecting to Microsoft SQL Server to Execute a Transformation Map
When the Transformation map 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 2000: For Microsoft SQL Server 2005: |
| Database connection string |
Following is a sample JDBC connection string to connect to the Microsoft SQL Server database named TUTORIAL running on the server named TEST0101: jdbc:sqlserver://TEST0101:1433;databasename=TUTORIAL |
Further considerations
- The Database Configuration should specify the username and password of the Windows or SQL Server user authorized to perform the database transactions.
If necessary, you can download the Microsoft SQL Server JDBC Driver 3.0 from this location. Make sure that this driver version is appropriate for your Windows system and Microsoft SQL Server database. Downloads of other JDBC driver versions may also be available:
Download: Microsoft SQL Server JDBC Driver 3.0
- The Microsoft SQL Server JDBC Driver 3.0 is implemented in the file sqljdbc.jar (for Java 1.5) or sqljdbc4.jar (for Java 1.6 and above). You may need to copy the file to the /jar directory of your JSM instance and restart the Java Service Manager before using the driver with Transformation Maps in LANSA Composer.
- If you are using integrated Windows authentication to connect to the Microsoft SQL Server database, then it may also be necessary to copy the appropriate version of the file into your /Windows/System32 directory. Versions of this file for 32-bit and 64-bit Windows environments are supplied and installed with the Microsoft SQL Server JDBC Driver. Refer to the driver documentation for more information.
- Refer to relevant Microsoft resources for more information on the JDBC drivers available for Microsoft SQL Server and the keywords and values that can be specified in the JDBC connection string. Following are some useful references. Note that some of these references relate to specific versions of Microsoft SQL Server and associated software. You should refer to the equivalent pages for the software versions you are using.
Microsoft SQL Server JDBC Driver 3.0
ConnectionStrings.com - Forgot that connection string? Get it here!