Toad World® Forums

Toad Intelligence Central iSeries ODBC

I am setting up my ODBC connections for Toad Intelligence Central. I don’t see a “Data source type” of iSeries to connect to my DB2 database on my AS400. How do I connect?

tic.png

To connect to iSeries with Admin Console you would use the ODBC connection type. If want to publish to Toad Intelligence Centrail from Toad Data Point you would need to define an ODBC DSN using the Operating Systems ODBC Manager. Use the 32-bit manager.

Here is the help topic on this.

Create IBM DB2 iSeries ODBC Connections

Toad allows you to connect to an IBM DB2 iSeries database using ODBC connectivity. Download and install the necessary ODBC driver to use for your DB2 iSeries connection prior to creating the new connection in Toad.

To create a DB2 iSeries ODBC connection

Click on the toolbar (ALT+F+N+O).

Select IBM DB2 iSeries from the Group list box.

Click in the Data Source Name field.

Click Add.

Select an IBM DB2 iSeries ODBC driver from the list, and click Finish.

Specify the configuration properties required for the database in the windows configuration dialog.

Specify the connection properties in the Create New Connection dialog. Review the following for additional information:

General

Use data source name

Select to display the Data source names.

Do not select this option if you want to display the driver names.

Data source name

Select the driver or data source name you added in the previous steps.

User

Enter the user name to use when connecting.

Password

Enter the password to use when connecting.

Tip: After connecting, you can set a master password to further secure your connection in Tools | Options| Environment | Security.

Database

Specify the location of the database schema. Click to create a temporary connection and display available schemas in the drop-down list.

Information

Data Source Name

Displays the selected driver or data source name.

Driver

Displays the ODBC driver associated with the data source.

Category (Optional) Select an existing category or create a new one. See Set Connection Categories for more information.

Click Connect to connect immediately while saving the connection information. Optionally, click Save to save the connection without connecting.

Tip: Connections are stored in the connections.xml file and can be found by clicking the Application Data Directory link in Help | About.

Related Topics

Connection/Navigation Manager

Understand Toad Connections

Switching Connections in Toad