Impact Integration with Netezza
Lorna Kelleher 270005WTBR Visits (2019)
How to enable Netcool Impact to connect to a Netezza database.
1. Acquire the Netezza driver jar.
The drivers are available via FixCentral -> http
2. Install the Netezza driver jar into your Impact installation.
Add the Netezza driver jar to the following directory on your Impact installation: $IMPACT_HOME/dsalib
3. Create a data source in Impact of type -> Generic SQL
The URL field should take the following format:
4. Create a date type.
Right click on the new data source and select, New Data Type.
Insert the name of one of the Netezza database tables into the Base Table field.
Click on Refresh.
This will import the table fields.
Click on save to save the data type.
5. View data items.
Right click on new data type and select View Data Items
Table rows will then be displayed.