Skip to main content

ODBC

Connecting Microsoft Excel to the Timbr Knowledge Graph​

  1. Install Microsoft Spark ODBC driver (64-bit):
    https://www.microsoft.com/en-us/download/details.aspx?id=49883
    In the main window under Connect go to the To a Server list and click on More...
  2. Open the 64-bit ODBC Administrator pane
    (C:\ProgramData\Microsoft\Windows\StartMenu\Programs\Administrative Tools)
    or
    https://www.top-password.com/blog/open-odbc-data-source-administrator-in-windows-10

A. In the User DSN tab click Add.

image

B. Select the Microsoft Spark ODBC driver and click Finish.

image

C. In the setup window that appears fill in the details:

Datasource Name: timbr

IP/Hostname: <IP/HOSTNAME> (without HTTP/HTTPS)

Port: 443 or 80 or 11000 (443 for HTTPS and 80 or 11000 for HTTP)

Database: leave empty

Mechanism: User Name and Password

Username: token@<knowledge graph name>

Password: <token>

Thrift Transport: HTTP

HTTPS Options...: Click to add the HTTP path.

image

D. Insert the following as the HTTP Path: /timbr-server/ontology/<ontology_name>

Once inserted click OK.

image

SSL Options...: Click and mark Enable if SSL is enabled, or unmark if SSL is not enabled in the environment. Once marked or unmarked click OK.

Next, on the bottom of the setup window click on Test to test the connection. You should get a \"SUCCESS\" message and the DB will be added.

image

Click on OK to finish the setup.

** In case you receive an error message please repeat the steps and address the error according to the message.

E. Select the newly added data source and click OK.

image

  1. Open Excel:

A. Go to the Data tab and click on Get Data, select From Other Sources and choose From ODBC.

image

B. Select the "timbr" datasource.

image

C. Here you have two options:

  • Click on Advanced options to write a query and get the data according to your query.
  • Click on OK to load data from a specific concept.

image

D. Enter credentials again and click Connect:

Username = token@<knowledge graph name>

Password = <your_personal_token>

image

E. In the navigator window that appears choose the schema and concept you would like to load from the list and click Load.

image

Congrats! Excel will now load the data or queries you chose and show the results as a table.