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 Credentials and Certificates, you can use secrets if a vault is configured for the platform and the service supports vaults. For information, see Using secrets from vaults in connections.
Choose the method for creating a connection based on where you are in the platform
In a project Click Add to project > Connection. See Adding a connection to a project.
In a catalog
Click Add to catalog > Connection. See Adding a connection asset to a catalog.
In a deployment space
Click Add to space > Connection. See Adding connections to a deployment space.
In the Platform assets catalog
Click New connection. See Adding platform connections.
Next step: Add data assets from the connection
Where you can use this connection
You can use SAP IQ connections in the following workspaces and tools:
Analytics projects
- Metadata import (Watson Knowledge Catalog)
- SPSS Modeler (SPSS Modeler service)
Catalogs
- Platform assets catalog
- Other catalogs (Watson Knowledge Catalog)
SAP IQ setup
Restriction
For SPSS Modeler, you can use this connection only to import data. You cannot export data to this connection or to a SAP IQ connected data asset.
Running SQL statements
To ensure that your SQL statements run correctly, refer to the SAP IQ documentation for the correct syntax.
Learn more
Parent topic: Supported connections