2018.1

ODBC DataSource
1. Select the ODBC system data source. Note: Only 32-bit data sources are currently shown
in this dialog, even if your system is 64-bits.
2.
Click Next and enter the information for the source table.
l
Connection string: Displays the full path to the database.
l
Table: Use the drop-down to select the appropriate table or stored query to retrieve
the appropriate data set.
l
Encoding: Use the drop-down to select the encoding with which to read the data in
the table.
3.
Click Finish to open the database
JDBC
1. Enter the appropriate information to connect to the database:
l
JDBC Driver: Use the drop-down to select which JDBC Driver to use for the
database connection.
l
JAR file path: Enter a path to the JAR file that contains the appropriate driver for the
database below.
l
Server: Enter the server address for the database server.
l
Port: Enter the port to communicate with the server.
l
Database name: Enter the exact name of the database from where the data should
be extracted.
l
User name: Enter a username that has access to the server and specified
database. The user only requires Read access to the database.
l
Password: Enter the password that matches the username above.
l
Advanced mode: check to enable the Connection String to manually enter the
database connection string.
l
Connection string: Type or copy in your connection string.
Page 666