INFO
Amazon Athena DB is a query service in that companies are able to run SQL queries against their data as though it resides in a local data center.
Prerequisites
Preparing Netezza DB
INFO
Set up your Netezza database accordingly.
Uploading the Database Driver
INFO
Set up the database driver in the 'Admin' tab.
Configuring Netezza DB as a Connection
To configure Netezza DB as a connector:
- Click the "+" button and select "Connection" or right-click in the File Browser and select "Create New" → "Connection". The "New Connection" tab appears in the menu bar.
or - Select "Netezza" from the drop-down and confirm with "Next". The type is displayed in the drop-down.
- Enter the connection string from the database driver and select the connection usage from the drop-down.
- Choose "Provide credentials", enter the username and password from the connection string and confirm with "Next". The 'Save Connection' tab opens.
- If needed, enter a description and confirm with "Next". The 'Save Connection' dialog opens.
- Select the folder to save the connection, enter a name in "Save as" and confirm with "Save". The connection is saved. Configuring the Netezza connection is finished.
Importing Data with a Netezza Connector
INFO
Find how to import from Netezza here.
Exporting Data with a Netezza Connector
INFO
Find how to export to Netezza here.