External Databases

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

  • MySQL
  • PostgreSQL
  • Redshift
  • Vertica
  • BigQuery

To gain access to these databases, simply navigate to 'New Project' in the Omniata main page, and select 'External Database', name your Project, and provide the requested credentials. Once approved, Omniata requests to confirm the schema to ensure that the data can be used for data visualization.

An important aspect to remember is that using database connections only provides a view option of the data stored externally. No modifications can be made to the SQL tables from Omniata. Furthermore, the database connections are static in a sense that they do not enable Campaigns or User Acquisition marketing information. To use these Omniata features, application needs to be connected to Omniata with real-time event data.

This article was last updated on December 2, 2015 22:53. If you didn't find your answer here, search for another article or contact our support to get in touch.