InterSystems Caché Database

This example discusses how to connect Tableau to a InterSystems Caché database. Connecting to this data source requires a special license for Tableau that has Caché enabled. Additionally, you or a database administrator must load a stored procedure into your Caché database before you connect using Tableau.

Loading the Stored Procedure

  1. Copy the XML file on the following webpage to the Caché server: www.tableausoftware.com/community/support/cache
  2. Start Caché Studio at the server from the Cube in the system tray.
  3. Within Studio, select Tools > Import Local.
  4. In the subsequent dialog box select the XML file.
  5. In the Import dialog box, make sure both the class name TableauFuncs and Compile Imported options are selected.
  6. Click OK.

Connecting to the Database

  1. Select Data > Connect to Data to open the Connect to Data page.
  2. Select InterSystems Caché.
  3. Follow the steps in the InterSystems Caché Connection dialog box to complete the connection.
    1. Step 1 – Type the namespace on the server that hosts the database.
    2. Step 2 – Enter the database name that you want to connect to.
      Servers often contain multiple databases. Type the name of the specific database on the server that you want to connect to. Database names are case sensitive.
    3. Step 3 – Enter your username and password to log on to the server.
    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 – Select a table or view from the database.
      InterSystems Caché 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.
    6. Step 6– 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 InterSystems Caché is shown below.

5 comments:

  1. Does this mean I can connect Intersystem's TrakCare into Tableau?

    ReplyDelete
  2. This comment has been removed by the author.

    ReplyDelete
  3. This comment has been removed by the author.

    ReplyDelete
  4. Where is the xml file referenced above? The link is broken.
    Thanks.

    ReplyDelete
  5. Nice Informations.
    Really awesome tips about Intersystems Caché database and Intersystems database connection.
    Here 4W also provides best support and development for Intersystems cache

    ReplyDelete