Importing data from databases

Often, you need to connect to a database server. Domo has connectors for databases such as Snowflake, Mongo, Vertica, Oracle, SQL Server, MySQL, Postgres, IBM DB2, Informix, Sybase, Redshift, Aurora, Google Cloud Storage, Google Big Query, Hive, Teradata, and Firebase.

These connectors are found in the DATA menu and the DATABASE submenu. These connectors make it easy to connect to many popular databases. However, for these connectors to access the databases directly from the cloud, the database server firewalls may need to whitelist the Domo connector services' IP addresses. Here is a detailed list of the IP addresses to whitelist: https://bit.ly/3mp0vmc.

If you have direct access to one of the database systems listed, then follow these steps:

1. Click on the DATA main menu item.
2. Click on the DATABASE sub-menu item.
3. Search for the database.
4. Click on the database tile.
5. Click the CONNECT button in the tile.
6. Click the orange...