Informatica (via Collector method) - v3.0.4

This collector is for Informatica versions prior to Informatica Intelligent Cloud Services (IICS)

About Collectors

Pre-requisites

Collector Server Minimum Requirements

Informatica Requirements

Informatica 9.1+ with repository hosted in Oracle.
Access to Informatica Repository (see section below)
- Establish Informatica Repository Access
  - Create an Oracle user with read access to all tables in the Informatica repository database.
- Establish Informatica Server Access
  - Create a user that has read access to the Informatica Server.

Step 1: Create the Source in K

Create a Informatica source in K

Go to Settings, Select Sources and click Add Source
Select "Load from File" option
Give the source a Name - e.g. Informatica Production
Add the Host name for the Informatica Server
Click Finish Setup

Step 2: Getting Access to the Source Landing Directory

Step 3: Install the Collector

It is recommended to use a python environment such as pyenv or pipenv if you are not intending to install this package at the system level.

Some python packages also have dependencies on the OS level packages, so you may be required to install additional OS packages if the below fails to install.

You can download the Latest Core Library and whl via Platform Settings → Sources → Download Collectors

Run the following command to install the collector

pip install kada_collectors_extractors_<version>-none-any.whl

You will also need to install the common library kada_collectors_lib for this collector to function properly.

pip install kada_collectors_lib-<version>-none-any.whl

You may require an ODBC package for the OS to be installed as well as an oracle client library package if do you not have one already, see https://www.oracle.com/au/database/technologies/instant-client.html

Step 5: Configure the Collector

The collector requires a set of parameters to connect to and extract metadata from Informatica

FIELD	FIELD TYPE	DESCRIPTION	EXAMPLE
username	string	Username to log into Oracle	"myuser"
password	string	Password to log into Oracle
dsn	string	Datasource Name for Oracle, this can be one of the following forms <tnsname>
host/servicename> \|	preprod" \|
repo_owner	string	This is the owner of all the tables required by the extractor	"inf"
oracle_client_path	string	Full path to the location of the Oracle Client libraries, this can be left empty if you do not use any specific client library.	"/tmp/drivers/lib/oracleinstantclient_11_9"
cached	boolean	If set to true if will prevent re-extracting data	false
input_path	string	Absolute path to the input location where `runtime_session_overrides.json` is placed	"/tmp/input"
output_path	string	Absolute path to the output location where files are to be written	"/tmp/output"
mask	boolean	To enable masking or not	true
compress	boolean	To gzip the output or not	true