Sybase IQ
Connection Type | ODBC (64-bit) |
Type of Support | Read & Write |
Validated On | Database Version: 16.1 ODBC Client Version: 17.00.7.531 |
Driver Details
For download and more information about the SAP IQ ODBC Driver, see SAP Help Portal.
Alteryx Tools Used to Connect
Standard Workflow Processing
Input Data Tool
Output Data Tool
Read and Write Support with DCM Connection
Drop the Input tool or the Output tool on the canvas.
Select the Use Data Connection Manager (DCM) and select Set Up a Connection.
Locate SAP IQ on the list of data sources. Both ODBC and Quick connect options are available.
Once you select Quick connect, you will receive a list of inputs required to set up a connection with a SAP instance.
Fill out the details and save the connection.
Select the Connect button.
Read and Write Support without DCM Connection
Drop the Input tool or the Output tool on the canvas.
Deselect the Use Data Connection Manager (DCM) checkbox and select Set Up a Connection.
Locate SAP IQ on the list of data sources. Select your pre-configured DSN for this connection.
Fill out the details and save the connection.
Select the Connect button.
Note
SAP IQ doesn't allow username or password to contain semicolons.