Versions Compared

Old Version 1

changes.mady.by.user Kirstin Seidel-Gebert

Saved on

compared with

New Version Current

changes.mady.by.user Annegret Bernhardt

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Published by Scroll Versions from space WBRIDGE and version 24.0
Info

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.

...

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.

Image Modified

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).

...