Skip to content

Connecting your data

This page shows you how to connect the data Zinye Insights builds charts from. You do this once per source, then everyone can build on it.

Zinye Insights can pull from several kinds of source:

  • Your Zinye ERP and other business databases
  • Other databases (such as MySQL or PostgreSQL)
  • Files and spreadsheets you upload

You can combine more than one source, so a single dashboard can draw on everything.

  1. Open Data Sources.
  2. Click + Add Data Source.
  3. Pick the type of source.
  4. Enter the connection details (for a database: host, name, and the login it should use; for a file: upload it).
  5. Save and test the connection.

From Data Sources you can see everything that’s connected, edit a connection, or remove one you no longer use. Once a source is connected, its tables become available to pick from when you build a query.