External Databases

Omniata can connect to several different databases, which allows visualization of external data in the platform. Currently, Omniata supports the following database connections:

  • MySQL
  • PostgreSQL
  • Redshift
  • Vertica
  • BigQuery

Adding External Databases

To connect to your external database, simply select the right External Database Project from the New Application menu, provide a name for it, and add the requested credentials. Once connected, Omniata requests to confirm the schema to ensure that the data can be used for data visualization.

When using database connections take into account:

  • Omniata provides a view option of the data stored externally.
  • No modifications can be made to the SQL tables from Omniata.
  • Database Connections are static in a sense that they do not enable Campaigns or User Acquisition marketing information. To use these Omniata features, an application needs to be connected to Omniata with real-time event data.

As the External Database Projects only read from externally hosted databases, there are only limited options for data modeling. The only aspect that can be managed is the use of Table Fields. Please go to sections on Fields to review the options available for Table Fields.

This article was last updated on May 5, 2017 09:25. If you didn't find your answer here, search for another article or contact our support to get in touch.