View Source

This page explains the SQL Adapter in Bridge context. If you were looking for the same information regarding the PAS Designer, refer to SQL Adapter in the Designer guide.

It can happen that in certain situations it is not possible to directly connect via the E2E Bridge to a specific DBMS. For instance if the service is running on an AIX UNIX system and needs to access a Microsoft SQLServer. To be able to do this you can use ODBC (Open Database Connectivity), which provides an open standard software API to connect to various database management systems.

Check Installing and Configuring Database Access for information on how to configure ODBC.

Using ODBC data sources with the E2E Bridge is done using the <<SQLAdapter>>, the same way you would use the adapter with a standard DBMS.

BRIDGE > ODBC > backend_service_type_selection_odbc.png

In order to use an ODBC data source, choose ODBC when selecting the backend service type template in the E2E Components Wizard.

Further, the name of the ODBC data source needs to be defined in tagged value dbConnectionString of the <<SQLAlias>> (NorthwindCustomers).

BRIDGE > ODBC > component_diagram_for_odbc.png

The ODBC functionality of the <<SQLAdapter>> only works with data sources that have a username/password authentication.

BRIDGE > ODBC > component_diagram_for_odbc_v1.png