SAP IQ connection

To access your data in SAP IQ, create a connection asset for it.

SAP IQ is a column-based, petabyte scale, relational database software system used for business intelligence, data warehousing, and data marts. SAP IQ was formerly Sybase IQ.

Create a connection to SAP IQ

To create the connection asset, you need these connection details:

  • Database name
  • Hostname or IP address
  • Port number
  • Username and password
  • SSL certificate (if required by the database server)

For Private connectivity, to connect to a database that is not externalized to the internet (for example, behind a firewall), you must set up a secure connection.

SAP IQ setup

Getting Started with SAP IQ

Restriction

You can use this connection only for source data. You cannot write to data or export data with this connection.

Running SQL statements

To ensure that your SQL statements run correctly, refer to the SAP IQ SQL Reference for the correct syntax.

Learn more