Sybase IQ Database

This example discusses how to connect Tableau to a Sybase IQ database.
  1. Select Data > Connect to Data to open the Connect to Data page.
  2. Select Sybase IQ.
  3. Follow the steps in the Sybase IQ Connection dialog box to complete the connection.
    1. Step 1 – Enter the server name that hosts the database you want to connect to.
    2. Step 2 – Enter a database name on the server.
      Servers often contain multiple databases. Type the name of a specific database on the server. Database names are case sensitive.
    3. Step 3 – Provide log in information for the server.
      Specify whether to use Windows NT Integrated security or a specific username and password.
    4. Step 4 – Test the connection.
      If the connection is successful, Tableau will alert you. If the connection is unsuccessful, verify that your user name and password are correct. If the connection continues to fail, your computer is having trouble locating the server. Contact your network administrator or database administrator.
    5. Step 5 – Use the drop-down list to select a schema on the server.
    6. Step 6 – Select a table or view from the database.
      Sybase IQ databases can contain multiple tables and views. Specify which table or view within the database you want to connect to. You can also connect to multiple tables or a specific query by selecting the Multiple Tables and Custom SQL options.
    7. Step 7 – Give the connection a name for use in Tableau.
      Specify a unique name for the connection. The default name is automatically generated based.
A completed Connection dialog box for Sybase IQ is shown below.

1 comment: