Skip to main content

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

Read and Write Support with DCM Connection

  1. Drop the Input tool or the Output tool on the canvas.

  2. Select the Use Data Connection Manager (DCM) and select Set Up a Connection.

  3. Locate SAP IQ on the list of data sources. Both ODBC and Quick connect options are available.

  4. Once you select Quick connect, you will receive a list of inputs required to set up a connection with a SAP instance.

  5. Fill out the details and save the connection.

  6. Select the Connect button.

Read and Write Support without DCM Connection

  1. Drop the Input tool or the Output tool on the canvas.

  2. Deselect the Use Data Connection Manager (DCM) checkbox and select Set Up a Connection.

  3. Locate SAP IQ on the list of data sources. Select your pre-configured DSN for this connection.

  4. Fill out the details and save the connection.

  5. Select the Connect button.

Note

SAP IQ doesn't allow username or password to contain semicolons.