Openflow Connector for Microsoft Dataverse¶
Note
The connector is subject to the Connector Terms.
The Openflow Connector for Microsoft Dataverse connects a Microsoft Dataverse storage and Snowflake to ingest Microsoft Dataverse tables and keeps them up to date on Snowflake side. The outcome of the connector are selected tables replicated on Snowflake Account in a database and schema specified by the user.
Use this connector if you’re looking to do the following:
Integrate data from Microsoft Power Platform and Dynamics 365 applications with Snowflake for holistic business insights
Limitations¶
Only tables with enabled change tracking can be replicated
Schema of destination tables is discovered from the database metadata through REST APIs. Whenever new columns are added to the table, they appear in the destination table. Changes and removals of columns are not reflected in the destination table.
All limitations of Microsoft Dataverse Web API apply.
Supported set of column types is limited by set of types supported by Snowpipe Streaming.
Each instance of the connector supports a single schedule. If you need multiple schedules, then you need to install multiple instances of the connector.
Empty tables are not replicated.
Removal of a table is not replicated. If a table was replicated previously and is removed, it will remain in destination schema.