Administrator Guide

Back Next

Relational Database Connection Authentication Properties

A relational database connection includes the following authentication properties:

Use Trusted Connection: Microsoft SQL Server database. Indicates whether to use Windows authentication to access the database. The user name that starts the connection must be a valid Windows user with access to the Microsoft SQL Server database.
User: Name of the database user account. The database user must have read and write permissions to the database.
If you define a connection to an Oracle database to process BLOB, CLOB, or NCLOB data, the user must have permissions to access and create temporary tablespaces.

If you choose the option
Use Trusted Connection
, do not enter a user name here.
Password: Password for the database user account. The password must use 7-bit ASCII encoding.
If you choose the option
Use Trusted Connection
, do not enter a password here.
Database Name: Microsoft SQL Server database connected with native driver. Name of the database.
Default Schema Name: The name of the schema to which
Data Integration Hub
connects. You enter the default schema name only for an ODBC connection.

You cannot edit the

User

and

Password

properties for the connections to the

Data Integration Hub

repositories, DIH_REPO and DIH_STAGING, on the

Connections

page. For information about how you change users for those connections, see Managing User Credentials for System Connections.