Installing and configuring Integration Studio prerequisites
Refer to the sections below for installing and configuring the prerequisites for Integration Studio:
Installing the Perl execution environment
To develop Perl ETLs, the preferred Perl execution environment for Integration Studio under Windows is Cygwin (http://www.cygwin.org). You need to install and run Cygwin on your machine before installing Integration Studio. The x86 and x86-64 versions of Cygwin are supported.
The following Cygwin packages are required for developing Perl ETLs:
- gcc-core: 4.8
- gcc-g++: 4.8
- libcrypt-devel: 11
- make: 4
- perl: 5.14
- libsqlite3-devel: 3.8
- libcrypt-devel: 1.1 or earlier (for 64-bit environment only)
In addition to the packages listed above, the following packages are required for PostgreSQL database support:
- libpq-devel: 9.3, 9.4
- postgresql-client: 9.3, 9.4
In order to develop ETLs in Perl, you must install additional Perl libraries. Navigate to Windows > Preferences > Integration Studio, and click Check Perl prerequisites.
The list of libraries installed by Integration Studio are listed below:
- TimeDate version 1.16
- DBI (Database Interface) version 1.631
- DBD-SQLite version 1.42
- Object-MultiType version 0.05
- XML-Smart version 1.6.9
- PadWalker version 1.92
- DBD-Pg-3.1.1 - Required only if you are developing Perl modules that connect to a PostgreSQL database.
- DBD-Oracle-1.30 - Required only if you are developing Perl modules that connect to an Oracle database.
Additional Perl libraries can be downloaded and manually installed from the CPAN website (http://www.cpan.org/).
Install Oracle client
Oracle client is required to provide oracle database connectivity to developed ETLs and Reports. Installation of Oracle client is not mandatory if you don’t plan to connect to an Oracle Database.
Before proceeding with Perl module installation, you must configure the
ORACLE_HOME environment variable (For example,
C:\oracle\product\12.1.0\client_1) pointing to you oracle client installation. Install an oracle client version according to the installed Cygwin ( x86 or x86-64).
Configure Oracle JDBC driver location
If you want to develop ETLs in Java that connect to an Oracle database as a data source, it is necessary to add the Oracle driver to the ETL project.
- Right-click on the root node of the project
- Select Build path > Configure build path > Libraries > Add external Jar.
Install Oracle JDBC driver
To allow Integration Studio to connect to the BMC TrueSight Capacity Optimization database, the Oracle driver must be saved in the following sub-folder of the base Integration Studio installation directory:
The driver file is available in the following client installation directory of Oracle:
- $ORACLE_HOME\jdbc\lib subfolder
The name of the driver file is structured as ojdbcVERSION.jar, where VERSION is the version of the driver file that is being used.
Ensure that the Integration Studio is not running while the Oracle driver is being copied.