1. Home
  2. On-premises 5.1
  3. Guides
  4. Tours
  5. Concepts
  6. Tools
  7. References
    1. Apache Spark
    2. Connectors
      1. Amazon Web Services (AWS) Athena
      2. Amazon Web Services (AWS) DynamoDB
      3. Amazon Web Services (AWS) RedShift
      4. Amazon Web Services (AWS) S3
      5. Apache Drill
      6. Apache Hadoop HDFS
      7. Apache Hive
      8. Apache Kafka
      9. Box
      10. Cassandra (Simba)
      11. Cassandra (Incorta)
      12. Cisco Meraki
      13. Cosmos DB
      14. Custom CData
      15. Custom SQL
      16. Dropbox
      17. File System (LocalFiles)
      18. Freshservice
      19. Google BigQuery
      20. Google Drive
      21. Google Sheets
      22. IBM DB2
      23. IBM Netezza
      24. JIRA
      25. JSON
      26. Local Files
      27. Microsoft Azure Gen2
      28. Microsoft SharePoint
      29. Microsoft SQL Server
      30. Microsoft SQL Server (JTDS)
      31. MongoDB BI
      32. MySQL
      33. NetSuite - SuiteAnalytics
      34. NetSuite - Web Service
      35. OneLogin
      36. Oracle
      37. Oracle B2C Service
      38. Oracle Cloud Applications
      39. Oracle Essbase
      40. Oracle Sales Cloud
      41. PostgreSQL
      42. Presto
      43. Salesforce v1
      44. Salesforce v2
      45. SAP ERP
      46. SAP Hana
      47. SAP Sybase IQ
      48. ServiceNow
      49. Smartsheet
      50. Snowflake
      51. Splunk
      52. Teradata
      53. Vertica
      54. XML
      55. Zuora
    3. Built-in Functions
    4. Incorta Connector SDK
    5. Security
    6. Visualizations
    7. Other
  8. Integrations
  9. Data applications
  10. Releases

Netezza

Netezza connector properties

Parameter/SwitchDescription
UsernameUsername for IBM Netezza instance
PasswordPassword for Username
Connection Pool(defaults to 30)
Connection StringString describing how to connect with the IBM Netezza data source jdbc:netezza://<HOST>:<PORT>/<DATABASE_NAME>;readonly=true
Connection PropertiesAdditional required connection properties
Use Data AgentEnable using a data agent to securely ingest data from an external data source that is behind a firewall.
For more information, please review Tools → Data Agent and Tools → Data Manager.
Data AgentEnable Use Data Agent to configure this property. Select from the data agents created in the tenant, if any.

Important: Data Agent

A data agent is a service that runs on a remote host. It is also a data agent object in the Data Manager for a given tenant. An authentication file shared between the data agent object and the data agent service enables an authorized connection without using a VPN or SSH tunnel. With a data agent, you can securely extract data from one or more databases behind a firewall to an Incorta cluster. Your Incorta cluster can reside on-premises or in the cloud. A CMC Administrator must enable and configure an Incorta cluster to support the use of Data Agents. Only a Tenant Administrator (Super User) or user that belongs to a group with the SuperRole role for a given tenant can create a data agent that connects to a data agent service. To learn more, see Concepts → Data Agent and Tools → Data Agent.