Table of Contents

Search

  1. Preface
  2. Part 1: Installation Getting Started
  3. Part 2: Before You Install the Services
  4. Part 3: Run the Services Installer
  5. Part 4: After You Install the Services
  6. Part 5: Informatica Client Installation
  7. Part 6: Uninstallation
  8. Appendix A: Starting and Stopping Informatica Services
  9. Appendix B: Managing Distribution Packages
  10. Appendix C: Connecting to Databases from UNIX or Linux
  11. Appendix D: Updating the DynamicSections Parameter of a DB2 Database

Installation for Data Engineering

Installation for Data Engineering

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 need to create before the application services can access the associated databases.
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.
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.

0 COMMENTS

We’d like to hear from you!