Defining the database configuration for Microsoft Access

When the Transformation map (prepared as Java executable file) runs, it will use JDBC to establish the connection to the Microsoft Access 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 will use the JDBC-ODBC bridge included with your JDK on the Windows server running LANSA Composer in order to connect to your Microsoft Access database.  This approach requires that the machine also have the Microsoft Access ODBC driver installed.  There are also other JDBC solutions available for Microsoft Access from third-party providers.

Database driver class	Following is the class name used with the JDBC-ODBC bridge: sun.jdbc.odbc.JdbcOdbcDriver
Database connection string	Following is a sample JDBC connection string to connect to a Microsoft Access database using the JDBC-ODBC bridge: jdbc:odbc:;DRIVER=Microsoft Access Driver (*.mdb);DBQ=C:\COMPOSER\TUTORIAL\TUTORIAL.mdb

 

Further considerations

• The JDBC-ODBC bridge is deprecated and has been removed from Java 1.8 and above.  There are other JDBC solutions available for Microsoft Access from third-party providers.

• The Database Configuration need not specify a username and password unless you have defined security in your Microsoft Access database.