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: Connecting to Databases from UNIX or Linux

Installation for Enterprise Data Preparation

Installation for Enterprise Data Preparation

Data Asset Analytics Repository Database Requirements

Data Asset Analytics Repository Database Requirements

The Data Asset Analytics repository database stores the analytical information collected from the catalog. The analytical information is displayed as reports and statistical data in the
Analytics
tab in Enterprise Data Catalog. You can access the
Analytics
tab after you configure Data Asset Analytics in the Catalog Service and assign the required privileges for users to access the
Analytics
tab.
You can configure any of the following databases as the repository database for Data Asset Analytics:
  • Oracle
  • SQL Server
  • PostgreSQL

Oracle Database Requirements

Perform the following steps before you configure Oracle as the repository database:
  • Create a user name and password to access the Oracle database using the CREATE USER <Database Schema> command.
  • Provide the following privileges to the user name:
    • GRANT CONNECT TO <Database Schema>;
    • GRANT RESOURCE TO <Database Schema>;
    • GRANT CREATE VIEW TO <Database Schema>;
    • GRANT CREATE MATERIALIZED VIEW TO <Database Schema>;
    • GRANT UNLIMITED TABLESPACE TO <Database Schema>. Alternatively, use the command ALTER USER <Database Schema> QUOTA <SIZE> ON <tablespace name>;

SQL Server Database Requirements

Perform the following steps before you configure SQL Server as the repository database:
  • Make sure that you use the dbo schema for SQL Server.
  • Run the following commands to create the database, the user name, password and assign the required privileges for the user:
    • USE master
    • GO
    • CREATE DATABASE <new database name>;
    • GO
    • use <new database name>
    • CREATE LOGIN <new login name> WITH PASSWORD = '<password>';
    • CREATE USER <new user name> FOR LOGIN <new login name> WITH DEFAULT_SCHEMA = [dbo];
    • GRANT CREATE TABLE TO <new user name>;
    • GRANT CREATE VIEW TO <new user name>;
    • GRANT SELECT, ALTER, INSERT, DELETE, UPDATE on schema::dbo to <new user name> ;
    • GRANT REFERENCES to <new user name>;

PostgreSQL Database Requirements

Perform the following steps before you configure PostgreSQL as the repository database:
  • Make sure that you use the public schema for PostgreSQL.
  • Create the credentials to access the database using the following command: CREATE USER <new user name> WITH PASSWORD '<password>';
  • Create the database and assign the ownership to the user name that you created. Use the following command to complete this step: CREATE DATABASE <NEW db NAME> owner=<new user name>;
  • Make sure that you do not create a schema in the new database with the same name as the user name that you created.
  • After you connect to the new database, make sure that you run the command
    SHOW search_path
    . The command must return the value "
    $user", public
    .