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.

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: TCP/IP (default). Standard network protocol. Name Pipes. Windows-specific network protocol.
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.

See Also

• Creating a Data Source
• Data Source Description page