- Connecting to Different Databases

Connecting to Different Databases

WOW can connect to any database that supports a JDBC 2.0 driver.

This allows WOW applications to seamlessly combine data from any corporate data repository regardless of its location and RDBMS vendor. Below is a list of specific databases and what URL's are needed to connect to each of them. Replace the IP address listed with the IP address used to connect to your own database.

• • AS/400 (iSeries) - jdbc:as400:66.166.144.20

  • SQL Server - jdbc:microsoft:sqlserver://66.166.144.20

  • Oracle - jdbc:oracle:thin:@66.166.144.20:1521:METADATA

  • DB2 - jdbc:db2://66.166.144.20/DB_NAME

  • MySQL - jdbc:mysql://localhost/pjsys64

  • ODBC - jdbc:odbc:Data Source Name

  • PostgreSQL - jdbc:postgresql://66.166.144.20/DB_NAME

  • jTDS (used for SQL Server) - jdbc:jtds:sqlserver://66.166.144.20/DB_NAME

NOTE: Replace METADATA (Oracle), DB_NAME (DB2, PostgreSQL), or pjsys64 (MySQL) with the your database name. For ODBC, replace Data Source Name with the name of your DSN (which must be a system DSN that points to the desired Access database on your machine).