Loading Data from explore.attivio.com


The Attivio connector gives you access to data tables available at explore.attivio.com, and you can either import the data into Spotfire for further analysis, or keep it external as in-db data.

Note: You must have an Attivio DSD account, and you must have access to the Attivio DSD ODBC (Teiid) driver (where to download it is explained in the steps below) to be able to use the Attivio connector.

Note: As the number of in-database visualizations, filters, etc., increases, the live queries generated get more complex. Sometimes, the Attivio database engine will not be able to process these queries, which may prevent  visualizations and filters from being rendered. If you experience this issue, try using a mix of in-database data tables and in-memory data tables, or use in-memory data tables only.

Before you start working in Spotfire Analyst, you must log in to explore.attivio.com in a web browser, to retrieve the required connection details.

  1. In a web browser, go to https://explore.attivio.com/dsd/.

  2. Log in using your Attivio DSD username and password.

  3. Comment: You can get a trial account at https://signup.attivio.com/dsd/.

  4. Navigate to All Marts using the links at the top of the page.

  5. Click on the box for the mart of interest, so that detailed information about the mart is displayed to the right.

  6. Comment: If you click on the name of the mart, which is a link, the data will be opened in the browser. This is not what you want at this step, so make sure you only click in the box.

  7. In the details pane to the right, click Options.

  8. In the drop-down list, select Get Drivers.

  9. If you have not downloaded the required driver earlier, you can do so now. Otherwise, go to step 8.
    attivio_driver_download.png

  10. Comment: Make sure that you select the ODBC driver that matches the bitness of your computer (64-bit or 32-bit).

  11. Under ODBC, make a note of the Database name, Server and Port, or keep this web site open for the next task.
    attivio_connection_details.png

  1. In TIBCO Spotfire, select File > Add Data Tables.

  2. Click Add.

  3. Select Connection To > Attivio.

  4. Response: The Attivio Connection dialog is opened.

  5. In the Attivio Connection dialog, type or paste the connection details that you have gotten from the Attivio web site in the applicable fields:
    attivio_teiid_connection_d.png

  6. Comment: Note that there should not be any spaces in the database name; use underscore instead.

  7. Click Connect.

  8. Response: The Views in Connection dialog is displayed.

  9. In the Available tables in database list, select the tables you want to bring into Spotfire and click Add >.

  10. Optionally, you can join together related tables into a single view. This can be done in two different ways:
    A. Right-click on a table in the Views in connection list, and select either Add Related Tables or Add All Related Tables to add any related tables automatically.
    B. Right-click on a table in the Views in connection list, and then select New Relation to add a custom relation between two tables.

  11. Comment: See Structural Relations to learn more about adding relations.

  12. For each added view, choose which columns to import into Spotfire, by selecting or deselecting them in the Columns in selected view list.

  13. Tip: Tables may contain a large number of columns. Make sure you only import the columns you need by right-clicking anywhere in the Columns in selected view list, click Deselect All, and then select the columns of interest only.

  14. If desired, you can prompt the end users of the analysis to select specific values in the data only. Add prompting by clicking Define Prompting and specifying new prompts for suitable columns or parameters. To learn more, see Adding Prompts to Data Connections.

  15. When the configuration is done, click OK to close the Views in Connection dialog.

  16. In the Add Data Tables dialog, click OK.

    Response: Any defined prompts will be shown, and as soon as you have provided input in the prompts, the selected data is ready to be analyzed in Spotfire.

See also:

Attivio (Teiid) Data Types

Supported Functions