SAP Sybase IQ

SAP Sybase IQ connector properties

Parameter/SwitchDescription
UsernameUsername for SAP Sybase IQ instance
PasswordPassword for Username
Connection Pool(defaults to 30)
Isolation LevelPerformance versus Integrity balance.
Choices are:
  ●   Read Committed (high performance and good data consistency)
  ●   Read Uncommitted (highest performance and least data consistency)
Connection StringString describing how to connect with an SAP Sybase IQ instance jdbc:sybase:Tds:<HOST>:<PORT>/<DATABASE_NAME>
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.