Administrator Guide

10.4.0
- 10.5
- 10.4.1

Back Next

Relational Database Connection Data Access Properties

A connection includes the following data access properties:

Use This Connection for Data Access: Enable data access to the connection.
Connection String: Database connection string used to retrieve physical data objects from the database or to write physical data objects to the database.
Example syntax for Oracle:
oracle.world

Example syntax for Microsoft SQL Server:
sqlserver@mydatabase

For an ODBC connection, enter the ODBC connection string.
Domain Name: Name of the domain in which the database is running.
Server Name: Name of the server to which the relational database connects.
If you use a named database instance, specify the instance name in the following format:

<server_name>\<instance_name>

If you run multiple instances on the same database server with unique port numbers, you can specify the instance port number instead of the instance name in the following format:
<server_name>:<port_number>
where
server_name
is the name of the server to which database connects.

If you specify an instance name, verify that Microsoft SQL Server Browser is running.
Packet Size: Microsoft SQL Server database connected with native driver. Maximum packet size used to transfer data. Used to optimize native drivers for Microsoft SQL Server.
Code Page: Character encoding for the database.
Environment SQL: SQL commands that set the database environment each time you connect to the database. The SQL commands run with each database connection.
Default is disabled.

Oracle databases only: If you do not want to use the default schema to which
Data Integration Hub
connects, append the following string to the connection string:

ALTER SESSION SET CURRENT_SCHEMA=<schema name>

You must define the same schema in the Metadata Access section, in the
Connection String
field.
Transaction SQL: SQL commands that set the database environment at the beginning of each transaction. The SQL commands run before the initiation of each transaction.
Default is disabled.
Connection Retry Period: Number of seconds to wait before reconnecting to the database in case of connection failure.
Default value is 0.
Driver Type: The type of driver that you use to create a relational database connection. Choose one of the following options:
Native
.
Data Integration Hub
is installed on a Windows operating system.
ODBC
.
Data Integration Hub
is installed on a UNIX or a Linux operating system.

Rename Saved Search

Table of Contents

Administrator Guide

Administrator Guide

Relational Database Connection Data Access Properties

Relational Database Connection Data Access Properties