Installation and Configuration Guide > Part IV: After You Install the Services > Prepare to Create the Application Services > Create Connections
  

Create Connections

In the Administrator tool, create connections to the databases that the application services use. You need to specify the connection details while you configure the application service.
When you create the database connection, specify the database connection properties and test the connection.
The following table describes the database connections that you must create before you create the associated application services:
Database Connection
Description
Data object cache database
To access the data object cache, create the data object cache connection for the Data Integration Service.
Workflow database
To store run-time metadata for workflows, create the workflow database connection for the Data Integration Service.
Profiling warehouse database
To create and run profiles and scorecards, create the profiling warehouse database connection for the Data Integration Service. Use this instance of the Data Integration Service when you configure the run-time properties of the Analyst Service.
Note: To use the Microsoft SQL Server database as the profiling warehouse, choose ODBC as the provider type, and clear the use DSN option in the Microsoft SQL Server connection properties dialog box when you configure the Microsoft SQL Server connection.
Reference data warehouse
To store reference table data, create the reference data warehouse connection for the Content Management Service.

IBM DB2 Connection Properties

Use a DB2 for LUW connection to access tables in a DB2 for LUW database.
The following table describes the DB2 for LUW connection properties:
Property
Description
User name
Database user name.
Password
Password for the user name.
Connection String for metadata access
Connection string to import physical data objects. Use the following connection string: jdbc:informatica:db2://<host>:50000;databaseName=<dbname>
Connection String for data access
Connection string to preview data and run mappings. Enter dbname from the alias configured in the DB2 client.
Code Page
Database code page.
Environment SQL
Optional. Enter SQL commands to set the database environment when you connect to the database. The Data Integration Service executes the connection environment SQL each time it connects to the database.
Transaction SQL
Optional. Enter SQL commands to set the database environment when you connect to the database. The Data Integration Service executes the transaction environment SQL at the beginning of each transaction.
Retry Period
This property is reserved for future use.
Tablespace
Tablespace name of the DB2 for LUW database.
SQL Identifier Character
The type of character used to identify special characters and reserved SQL keywords, such as WHERE. The Data Integration Service places the selected character around special characters and reserved SQL keywords. The Data Integration Service also uses this character for the Support Mixed-case Identifiers property.
Support Mixed-case Identifiers
When enabled, the Data Integration Service places identifier characters around table, view, schema, synonym, and column names when generating and executing SQL against these objects in the connection. Use if the objects have mixed-case or lowercase names. By default, this option is not selected.

Microsoft SQL Server Connection Properties

Use a Microsoft SQL Server connection to access tables in a Microsoft SQL Server database.
The following table describes the Microsoft SQL Server connection properties:
Property
Description
User name
Database user name.
Password
Password for the user name.
Use Trusted Connection
Optional. When enabled, the Data Integration Service uses Windows authentication to access the Microsoft SQL Server database. The user name that starts the Data Integration Service must be a valid Windows user with access to the Microsoft SQL Server database.
Connection String for metadata access
Connection string to import physical data objects. Use the following connection string: jdbc:informatica:sqlserver://<host>:<port>;databaseName=<dbname>
Connection String for data access
Connection string to preview data and run mappings. Enter <ServerName>@<DBName>
Domain Name
Optional. Name of the domain where Microsoft SQL Server is running.
Packet Size
Required. Optimize the ODBC connection to Microsoft SQL Server. Increase the packet size to increase performance. Default is 0.
Code Page
Database code page.
Owner Name
Name of the schema owner. Specify for connections to the profiling warehouse database or data object cache database.
Schema Name
Name of the schema in the database. Specify for connections to the profiling warehouse or data object cache database. You must specify the schema name for the profiling warehouse if the schema name is different from the database user name. You must specify the schema name for the data object cache database if the schema name is different from the database user name and you manage the cache with an external tool.
Environment SQL
Optional. Enter SQL commands to set the database environment when you connect to the database. The Data Integration Service executes the connection environment SQL each time it connects to the database.
Transaction SQL
Optional. Enter SQL commands to set the database environment when you connect to the database. The Data Integration Service executes the transaction environment SQL at the beginning of each transaction.
Retry Period
This property is reserved for future use.
SQL Identifier Character
The type of character used to identify special characters and reserved SQL keywords, such as WHERE. The Data Integration Service places the selected character around special characters and reserved SQL keywords. The Data Integration Service also uses this character for the Support Mixed-case Identifiers property.
Support Mixed-case Identifiers
When enabled, the Data Integration Service places identifier characters around table, view, schema, synonym, and column names when generating and executing SQL against these objects in the connection. Use if the objects have mixed-case or lowercase names. By default, this option is not selected.
Note: When you use a Microsoft SQL Server connection to access tables in a Microsoft SQL Server database, the Developer tool does not display the synonyms for the tables.

Oracle Connection Properties

Use an Oracle connection to access tables in an Oracle database.
The following table describes the Oracle connection properties:
Property
Description
User name
Database user name.
Password
Password for the user name.
Connection String for metadata access
Connection string to import physical data objects. Use the following connection string: jdbc:informatica:oracle://<host>:1521;SID=<sid>
Connection String for data access
Connection string to preview data and run mappings. Enter dbname.world from the TNSNAMES entry.
Code Page
Database code page.
Environment SQL
Optional. Enter SQL commands to set the database environment when you connect to the database. The Data Integration Service executes the connection environment SQL each time it connects to the database.
Transaction SQL
Optional. Enter SQL commands to set the database environment when you connect to the database. The Data Integration Service executes the transaction environment SQL at the beginning of each transaction.
Retry Period
This property is reserved for future use.
Parallel Mode
Optional. Enables parallel processing when loading data into a table in bulk mode. Default is disabled.
SQL Identifier Character
The type of character used to identify special characters and reserved SQL keywords, such as WHERE. The Data Integration Service places the selected character around special characters and reserved SQL keywords. The Data Integration Service also uses this character for the Support Mixed-case Identifiers property.
Support Mixed-case Identifiers
When enabled, the Data Integration Service places identifier characters around table, view, schema, synonym, and column names when generating and executing SQL against these objects in the connection. Use if the objects have mixed-case or lowercase names. By default, this option is not selected.

Creating a Connection

In the Administrator tool, you can create relational database, social media, and file systems connections.
    1. In the Administrator tool, click the Manage tab.
    2. Click the Connections view.
    3. In the Navigator, select the domain.
    4. In the Navigator, click Actions > New > Connection.
    The New Connection dialog box appears.
    5. In the New Connection dialog box, select the connection type, and then click OK.
    The New Connection wizard appears.
    6. Enter the connection properties.
    The connection properties that you enter depend on the connection type. Click Next to go to the next page of the New Connection wizard.
    7. When you finish entering connection properties, you can click Test Connection to test the connection.
    8. Click Finish.