DB2

Before you begin

Before you begin, gather this connection information:

Name of the server that hosts the database you want to connect to (Host name) and port number
Database name
User name (User ID) and password
Are you connecting to an SSL server?

Port settings

The port number is dependent on the type of server you are connecting to and whether you are connecting to an encrypted port. Generally, use 50000 for a non-encrypted port and 60000 for an encrypted port. It is possible that your server is configured to use a non-standard port. Contact your administrator if you don't know which port to connect to.

SSL requirements

This connector enables you to connect to your server using SSL authentication. If you work in an SSL environment, your computer is probably already configured to support SSL. If you have trouble making an SSL connection with Tableau, make sure that the following IBM software is installed on your computer:

IBM Data Server Runtime Client v10.5fp3 or above
GSK8 SSL Library

Connect and set up the workspace

Launch Syntho and select Connect to a database, or under Create workspace, select DB2. For a complete list of data connections, select More under From database. Then do the following:

Enter the name of the server that hosts the database that you want to connect to.
Enter the port number.
Enter the database name to connect to the contained database.
Optionally, enter the schema name.
Enter your user name (User ID) and password.
Select the Require SSL check box when connecting to an SSL server.
Select Create Workspace. If Syntho can't make the connection, verify that your credentials are correct. If you still can't connect, your computer is having trouble locating the server. Contact your network administrator or database administrator.

Limitations

Batch reading and writing can be unstable and not as efficient as for other databases, but it will work in most cases.

Supported data types

PreviousMicrosoft SQL Server NextDatabricks

Last updated 2 months ago

Before you begin

Before you begin, gather this connection information:

Name of the server that hosts the database you want to connect to (Host name) and port number

Database name

User name (User ID) and password

Are you connecting to an SSL server?

Port settings

SSL requirements

IBM Data Server Runtime Client v10.5fp3 or above

GSK8 SSL Library

Note that the IBM Data Server Runtime Client and GSK8 Library must have the same bitness. For example, both must be either 32-bit or 64-bit. For more information, see on the IBM website.

Connect and set up the workspace

Enter the name of the server that hosts the database that you want to connect to.

Enter the port number.

Enter the database name to connect to the contained database.

Optionally, enter the schema name.

Enter your user name (User ID) and password.

Select the Require SSL check box when connecting to an SSL server.

Select Create Workspace. If Syntho can't make the connection, verify that your credentials are correct. If you still can't connect, your computer is having trouble locating the server. Contact your network administrator or database administrator.