Configure a Connection Profile

From the CData ribbon, click Get Data and select From DB2 connection/s to launch the CData Query window. To setup a new connection, you will have to click the New DB2 Connection button. Here you can set the connection settings, test the connection, and save the connection profile.

Connecting to DB2

Set the following properties to connect:

• Server: The name of the server running DB2.
• Port: The port the DB2 server is listening on.
• Database: The name of the DB2 database.

Authenticating to DB2

The add-in supports authenticating directly to the DB2 with user credentials as well as authenticating using the API key of an application integrated with DB2, such as Watson Query.

DB2 User Credentials

Set AuthScheme to USRIDPWD. Provide the following credentials:

• User: The username of a user with access to the database.
• Password: The password of a user with access to the database.

IAM

The add-in supports authenticating to the DB2 server using the API key of an application that connects to it, such as Watson Query.

Set AuthScheme to IBMIAMAuth. Provide the following credentials:

• User: The IBMid or service ID tied to a user of the DB2 server.
• Password: The API key associated with the application that requires access to the DB2 database.

Connection Properties

The Connection properties describe the various options that can be used to establish a connection.

Managing Connections

After successfully authenticating to DB2 you will be able to customize the data you are importing. To learn more about this, see Managing Connections.

See Also

• Querying Data: Use the data selection wizard to pull data into a spreadsheet. You can also configure scheduled data refresh here.
• Using the Excel Add-In: Find other ways to interact with DB2 data, such as using the available CData Excel Functions.