Data Source Fields for a Specific Database Management System
Go Up to Working with Data Sources
The following tables provide details about the data source fields that are specific to a database management system: DB2 LUW, DB2 z/OS, InterBase, Firebird, JDBC, MySQL, ODBC, Oracle, SQL Azure, SQL Server, Sybase, Sybase IQ.
You can access these fields when you create a data source or when you access the description page of an existing data source.
Contents
DB2 LUW
Item | Description |
---|---|
Use DB2 client aliases |
Check Enable to allow using DB2 client aliases. |
Host Name |
IP address or host name of the database server. |
Port |
Network port where the database server is listening. |
Remote DB Name |
Name of the target database. |
Schema ID |
Identifier of the target schema. |
Functional Path |
The functional path. |
OS Authentication |
Check Enable to log in to the database with the credentials of a user of the operating system where DB2 LUW is running. |
DB2 z/OS
Item | Description |
---|---|
Use DB2 client aliases |
Check Enable to allow using DB2 client aliases. |
Host Name |
IP address or host name of the database server. |
Port |
Network port where the database server is listening. |
Remote DB Name |
Name of the target database. |
Schema ID |
Identifier of the target schema. |
Functional Path |
The functional path. |
OS Authentication |
Check Enable to log in to the database with the credentials of a user of the operating system where DB2 z/OS is running. |
InterBase
Item | Description |
---|---|
Host Name |
IP address or host name of the database server. |
Port |
Network port where the database server is listening. |
Character Set |
Character set of the database. |
Dialect |
Dialect of the database. |
Role |
Role to access the database. |
Database file path |
Path to the database file. |
Firebird
Item | Description |
---|---|
Host Name |
IP address or host name of the database server. |
Port |
Network port where the database server is listening. |
Character Set |
Character set of the database. |
Dialect |
Dialect of the database. |
Role |
Role to access the database. |
Database file path |
Path to the database file. |
JDBC
Item | Description |
---|---|
Connection URL |
URL to connect to the database. |
MySQL
Item | Description |
---|---|
Host Name |
IP address or host name of the database server. |
Port |
Network port where the database server is listening. |
Default Database |
Name of the target database. |
Windows Authentication |
Check Enable to use native Windows authentication to connect to the target database. |
ODBC
Item | Description |
---|---|
Use DSN |
Check Enable to use DSN to connect to the target database. |
Connection String |
String that defined how to connect to the target database. |
Oracle
There are four different ways you can connect to an Oracle database. Use the Use combo box to select the system you want to use: Alias, Connect Descriptor, SID, Service Name.
Connecting to Oracle with Alias
Item | Description |
---|---|
TNSNames.ora Alias |
Alias to connect to the database. |
Instance Name |
Name of the database instance. |
Role |
Role to connect to the database. |
Windows Authentication |
Check Enable to use native Windows authentication to connect to the target database. |
Connecting to Oracle with Connect Descriptor
Item | Description |
---|---|
Connect Descriptor |
Description of the connection to the database. |
Instance Name |
Name of the database instance. |
Role |
Role to connect to the database. |
Windows Authentication |
Check Enable to use native Windows authentication to connect to the target database. |
Connecting to Oracle with SID
Item | Description |
---|---|
Host Name |
IP address or host name of the database server. |
SID |
Oracle system identifier that uniquely identifies the target database. |
Port |
Network port where the database server is listening. |
Instance Name |
Name of the database instance. |
Role |
Role to connect to the database. |
Windows Authentication |
Check Enable to use native Windows authentication to connect to the target database. |
Connecting to Oracle with Service Name
Item | Description |
---|---|
Host Name |
IP address or host name of the database server. |
Service Name |
Service name that identifies the target database. |
Port |
Network port where the database server is listening. |
Instance Name |
Name of the database instance. |
Role |
Role to connect to the database. |
Windows Authentication |
Check Enable to use native Windows authentication to connect to the target database. |
SQL Azure
Item | Description |
---|---|
Host Name |
IP address or host name of the database server. |
Default Database |
Name of the target database. |
SQL Server
Item | Description |
---|---|
Host Name |
IP address or host name of the database server. |
Port |
Network port where the database server is listening. |
Protocol |
Protocol to use for the network connection. You can choose any of the following options:
|
Encryption |
Check Enable to encrypt the network communication. |
Default Database |
Name of the target database. |
Packet Size |
Size of the network packets. |
Windows Authentication |
Check Enable to use native Windows authentication to connect to the target database. |
Sybase
Item | Description |
---|---|
Use Sybase SQL.INI aliases |
Check Enable to use Sybase SQL.INI aliases. |
Host Name |
IP address or host name of the database server. |
Port |
Network port where the database server is listening. |
Encryption |
Check Enable to encrypt the network communication. |
Default Database |
Name of the target database. |
Packet Size |
Size of the network packets. |
Max Connections |
Maximum number of connections that can be established. |
Character Set |
Character set of the database. |
Kerberos Authentication |
Check Enable to use the Kerberos network authentication protocol to connect to the target database. |
Sybase IQ
Item | Description |
---|---|
Host Name |
IP address or host name of the database server. |
Port |
Network port where the database server is listening. |
Database |
Name of the target database. |
Windows Authentication |
Check Enable to use native Windows authentication to connect to the target database. |