Using federated data connections

A good way to think of federated data is as an in-memory cache layer. Federated is a great fit when there are large existing data lake investments and infrastructure that can be accessed via Domo without replicating the data.

Follow these steps when you need to connect to a federated source that is accessing the data where it is currently stored outside of the Domo cloud. Federated sources supported at the time of writing are Amazon Athena, Amazon Redshift, Google Big Query, IBM DB2, Microsoft Azure, SQL Server, MySQL, Oracle, PostgreSQL, Presto, SAP Hana, and Snowflake:

1. Log in to your Domo instance.
2. Click on the DATA main menu item.
3. Click on the FEDERATED sub-menu item.
4. If you haven't created a federated account, do so now by clicking the ADD NEW ACCOUNT button in the bottom left corner.
5. Select the adaptor. In this case, let's choose PostgreSQL.
6. Click on the orange NEXT button.
7. Fill in the configuration...