Omniata can connect to several different databases, which allows visualization of external data in the platform. Currently, Omniata supports the following database connections:
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:
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.