Previous Topic: Convert Datatypes When Changing the Target DBMS

Next Topic: Database Connection Overview

DBMS Connection Software

The following table lists the client software required to connect from CA ERwin Data Modeler to the supported target servers. Work with your Database Administrator to install and configure the necessary software on the computer running CA ERwin Data Modeler. The client database software must be installed and configured before you can connect to a database to use features such as Reverse Engineer, Forward Engineer, and Complete Compare with that database.

Target DBMS

Client Software

Vendor/Provider

DB2 iSeries

IBM iSeries Access

IBM Corporation

DB2 z/OS

IBM DB2 Connect

IBM Corporation

DB2 LUW/UDB

IBM DB2 Connect

IBM Corporation

Informix

ODBC/Generic

IBM Corporation

MySQL

MySQL Connectors (ODBC, NET, Visual Studio Plugin, Java, MXJ)

MySQL AB

Oracle

SQL*Net or Net8 with configuration files (hosts, tnsnames.ora)

Oracle Corporation

Progress

ODBC

Progress Software

SAS

ODBC

SAS

SQL Server

SQL Server Client Tools

Microsoft Corporation

Sybase

Sybase Open Client

Sybase, Inc.

Sybase IQ

ODBC

Sybase, Inc.

Teradata

Teradata ODBC

NCR

More information:

Connect to the Database or Mart

Target Servers and the Physical Model