Selecting Database Type/Connectivity Options When Registering Datasources

Go Up to Manually Registering or Editing Datasources

The Datasource Registration Wizard’s Database Type panel lets you specify the basic connectivity method for the datasource you are creating.

Prior to registering datasources, you should be familiar with the connectivity options available for each DBMS platform.

• For DBArtisan system requirements and details on DBMS product support, see the Read Me at http://docs.embarcadero.com/products/dbartisan/.

Note: The Options Editor lets you indicate preferences, select options, and provide details not available with the Datasource Registration Wizard. For details, see Connection Options.

Note: On individual computers, administrators can restrict the available DBMS platforms available using registry settings. For details, see Locking Down Features Using the Registry.

To use IDERA’s default drivers requiring dedicated client software installed on the client machine

1. From the Available database types list, select one of the following:
   • IBM DB2 Universal Database
   • Microsoft SQL Server
   • MySQL
   • Oracle
   • PostgreSQL Servers
   • Sybase Adaptive Server
   • Sybase IQ
   • Teradata

   If there is currently a DBMS node selected in the Navigator/Explorer, that database type is automatically selected.

2. Click Next.

To specify a custom JDBC driver

1. From the Available database types list, select Generic JDBC.
2. Click Next.

To specify a generic ODBC driver or to use an ODBC connection

1. From the Available database types list, select Generic JDBC.
2. Click Next.