1. Home
  2. On-premises 5.2
  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. FTP
      20. Google BigQuery
      21. Google Cloud Storage
      22. Google Drive
      23. Google Sheets
      24. GraphQL
      25. IBM DB2
      26. IBM Netezza
      27. JIRA
      28. JSON
      29. Local Files
      30. Microsoft Azure Gen2
      31. Microsoft SharePoint
      32. Microsoft SQL Server
      33. Microsoft SQL Server (JTDS)
      34. MongoDB BI
      35. MySQL
      36. NetSuite - SuiteAnalytics
      37. NetSuite - SuiteQL
      38. NetSuite - Web Service
      39. OneLogin
      40. Oracle
      41. Oracle B2C Service
      42. Oracle Cloud Applications
      43. Oracle EPM
      44. Oracle Essbase
      45. Oracle Sales Cloud
      46. PostgreSQL
      47. Presto
      48. Salesforce v1
      49. Salesforce v2
      50. SAP ERP
      51. SAP Hana
      52. SAP Sybase IQ
      53. ServiceNow
      54. Smartsheet
      55. Snowflake
      56. Splunk
      57. SFTP
      58. Teradata
      59. Vertica
      60. XML
      61. Zuora
    3. Built-in Functions
    4. Incorta Connector SDK
    5. Security
    6. Visualizations
    7. Other
  8. Integrations
  9. Data applications
  10. Releases

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.