Skip to main content

Connect a Dataset

The first step to start getting answers from your data is to connect Veezoo to it. For that you will need to create a free account here, if you haven't already.

If you are signing up now, you can follow the onboarding steps to either choose a demo dataset or connect Veezoo to your own data. If you have already signed up before, just click on Studio on the Sidebar in Veezoo and then on '+ New Knowledge Graph' on the Sidebar in Studio to import a new dataset.

Open Studio

New Knowledge Graph

Usually you will get the most value of Veezoo with a live SQL database, but we also support Excel/CSV files. Here are all the currently supported data sources:

  • Amazon Redshift
  • BigQuery
  • Snowflake
  • PostgreSQL
  • Microsoft SQL Server
  • MySQL
  • Oracle
  • SAP HANA
  • IBM DB2
  • Exasol
  • Excel or CSV
  • Shopify
  • Google Sheets (coming soon)

Select from the tiles your data source and let's see what's next.

Choose a Knowledge Graph Name

Once you have selected your data source, you will need to choose a name for your Knowledge Graph. You will want to choose a name that corresponds to the data you are importing, such that your business users can understand, e.g. "Sales" or "Product Analytics".

Choose the Language

Additionally, you will have to select the language you want to use to ask questions in Veezoo for this dataset. Veezoo understands currently English, German, French and Italian. Keep in mind that it works best if your data is also on the same language, but you can manually configure it if needed.

You may add additional languages later to the same Knowledge Graph.

Connect to a SQL database

In the case of a SQL database, you will need to whitelist the IP 18.158.77.139 from the Veezoo application so it can access it securely.

Additionally, you may also want to connect over an SSH Tunnel by clicking on the checkbox at the end of the form.

Connect SQL

Connect to an Excel sheet

In the case of an Excel sheet, Veezoo will upload your Excel sheet securely to a PostgreSQL database managed by Veezoo, so that it is accessible only to your organization.

You can upload an Excel sheet with multiple worksheets, however pay attention to the limitations listed below the drop zone.

Connect Excel

Select Data

Here you can select the tables (or worksheets in the case of Excel) and the columns you are interested in to explore. Don't worry about selecting them all at once, you can always add more later.

tip

In fact, we recommend to start with a first set of interesting tables and columns and iteratively add more. For a specific table, make sure to import its primary key / ID and name columns and avoid rather technical columns.

Example: For users(ID, NAME, CREATED_AT, UPDATED_AT) I would definitely import ID and NAME, probably also CREATED_AT, but would leave UPDATED_AT (which may be a more technical column) for later.

Select Data