Table of Contents

Search

  1. Installation Overview
  2. Before You Install the Services
  3. Service Installation
  4. After You Install the Services
  5. Client Installation
  6. Uninstallation
  7. Starting and Stopping Informatica Services
  8. Connecting to Databases from Windows
  9. Connecting to Databases from UNIX
  10. Updating the DynamicSections Parameter of a DB2 Database
  11. Installation and Configuration Checklist
  12. Split Domain Configuration for Metadata Manager

Installation and Configuration Guide

Installation and Configuration Guide

Oracle Connection Properties

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.