Adding a Generic ODBC Data Source

Edit online

About this task

Note: My webMethods Server can use any ODBC connection that is manually configured at the operating system level (such as Windows Server). My webMethods Server uses a standard Java JDBC-ODBC bridge driver to connect to the ODBC data sources on the underlying operating system. Consult you Microsoft vendor documentation for details on how to configure an ODBC data source at the operating system level.

To connect a generic ODBC data source to My webMethods Server, use the following procedure:

To add a new data source for generic ODBC databases

Procedure

  1. To navigate to the correct page, do one of the following:
    • In My webMethods: Navigate > Applications > Administration > My webMethods > Data Sources > Add DataSource.
    • As system administrator: Administration Dashboard > Configuration > DataSource Administration > Add DataSource.
  2. Type a unique DataSource Name to be used by My webMethods Server on the View DataSources panel.
  3. Type a Display Name to be used when you identify a data source to use for a database directory service.
  4. Select Generic ODBC from the Server Type list and click Next.
  5. Type the ODBC data source name that matches the ODBC data source configured at the operating system level.
  6. Type a valid user name and password that, at a minimum, has READ access to the database to which you are connecting.
  7. Click Submit.