1. Home
  2. Guides
  3. Concepts
  4. Tools
  5. References
    1. Apache Spark
    2. Built-in Functions
    3. Incorta Component SDK
    4. Incorta Connector SDK
    5. Connectors
      1. AlloyDB
      2. Amazon Web Services (AWS) Athena
      3. Amazon Web Services (AWS) DynamoDB
      4. Amazon Web Services (AWS) RedShift
      5. Amazon Web Services (AWS) S3
      6. Apache Drill
      7. Apache Hadoop HDFS
      8. Apache Hive
      9. Apache Kafka
      10. Apache Kafka V2
      11. Autoline
      12. Box
      13. Cassandra (Simba)
      14. Cassandra (Incorta)
      15. Cisco Meraki
      16. Cosmos DB
      17. Custom CData
      18. Custom SQL
      19. Dropbox
      20. File System (LocalFiles)
      21. Freshservice
      22. FTP
      23. Google BigQuery
      24. Google Cloud Storage (GCS)
      25. Google Drive
      26. Google Sheets
      27. GraphQL
      28. IBM DB2
      29. IBM Netezza
      30. JD Edwards
      31. JIRA
      32. JSON
      33. Kyuubi
      34. Local Files
      35. MariaDB
      36. Microsoft Azure Gen2
      37. Microsoft OneDrive
      38. Microsoft SharePoint
      39. Microsoft SQL Server
      40. Microsoft SQL Server (JTDS)
      41. MongoDB BI
      42. MySQL
      43. NetSuite - Saved Searches
      44. NetSuite - SuiteAnalytics
      45. NetSuite - SuiteQL
      46. NetSuite - Web Service
      47. OneLogin
      48. Oracle
      49. Oracle B2C Service
      50. Oracle BI Publisher
      51. Oracle Cloud Applications (UCM)
      52. Oracle Cloud Applications
      53. Oracle CPQ
      54. Oracle EPM
      55. Oracle Essbase
      56. Oracle OTM/GTM
      57. Oracle Sales Cloud
      58. Oracle WMS
      59. PostgreSQL
      60. Presto
      61. Salesforce v2
      62. SAP ERP
      63. SAP Hana
      64. SAP Sybase IQ
      65. ServiceNow
      66. SFTP
      67. Smartsheet
      68. Snowflake
      69. Splunk
      70. Teradata
      71. Vertica
      72. XML
      73. Zuora
    6. Nexus
    7. Data Studio
    8. Public API
    9. Security
    10. SQL Interface
    11. Visualizations
    12. Other
  6. Integrations
  7. Data applications
  8. Release Notes
  9. Incorta Premium

Vertica

Vertica connector properties

Parameter/SwitchDescription
UsernameUsername for Vertica instance
PasswordPassword for Username
Use Secret ManagerAvailable only when you configure a secret manager in the CMC.
Select the checkbox to enter the password identifier in the integrated secret manager instead of its value.
Password IdentifierAvailable when you select the Use Secret Manager checkbox.
Enter the identifier of the user password.
Connection Pool(defaults to 30)
Connection StringString describing how to connect with the Vertica data source jdbc:vertica://<HOST>:<PORT>/<DATABASE_NAME>
Connection PropertiesAdditional required connection properties
Extra OptionsEnter supported extra options in the form of key=value.
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. You must have the Incorta cluster enabled and configured to support the use of Data Agents. To learn more, see Concepts → Data Agent and Tools → Data Agent.