Share post

Share post

Share post

Blog: Product

Ingest from Dynamics 365 Business Central to Snowflake with Omnata

Ingest from Dynamics 365 Business Central to Snowflake with Omnata

Plugins |

New features

By: Chris Chandler

3 July 2025

Omnata has just released its connector for Microsoft Dynamics 365 Business Central.

You can use this plugin, you can ingest data from your Business Central organisation, across all of your companies.

About Omnata Sync

Omnata Sync is a first of its kind native integration app for Snowflake that enables customers to sync data to and from SaaS endpoints and databases. Omnata Sync deliver significant benefits over middleware tools:

  • Easy to use - runs natively in your Snowflake deployment with no containers

  • Plug & Play connectors - so you don't spend time building flows or scripting configs

  • No data-handling infrastructure - so it's easier to get approved by cyber-security

  • Lower cost - free yourself uncertain ‘pay per row’ integration pricing models

Ingest unlimited data as often as you need

Omnata's native app architecture is the simplest and easiest way to ingest into Snowflake. Omnata's plug & play connectors require no complex config, and automate the many edge cases of data replication.

In addition, because Omnata doesn't process your data in its own cloud instance they pass on the savings to customers in the way of flat, unlimited usage pricing. A game-changer in a world of SaaS integrators that charge you by the record.

Supports all Business Central Endpoints

With a long legacy in the ERP space, Business Central has evolved over the years and many customers have years to decades worth of data. Omnata supports the three best practice patterns to extract data from BC:

  • Standard APIs - v2.0

  • Custom APIs - also known as 'Advanced APIs' in the Power suite.

  • OData

With these three endpoints, customers can extract all their current and historical data.

Omnata is trusted by Jade Software with Business Central as a critical source

After running into some challenges with existing SaaS integration tools, James Graham, the head of analytics at Jade, decided to pivot to use Omnata. Ultimately, an agile, three-way partnership between Omnata, Data Engineers and the team at Jade turned the project around to a success. Omnata is used to ingest ERP data from Microsoft Dynamics.

Read the full case study→

Get started with the BC plugin today

For a 30-day free trial, visit the marketplace and install into your Snowflake account in minutes.

https://app.snowflake.com/marketplace/listing/GZSUZ13JOKSK/omnata-omnata-microsoft-dynamics-365-business-central

Got more questions?

Get in touch with us for a chat.

Omnata has just released its connector for Microsoft Dynamics 365 Business Central.

You can use this plugin, you can ingest data from your Business Central organisation, across all of your companies.

About Omnata Sync

Omnata Sync is a first of its kind native integration app for Snowflake that enables customers to sync data to and from SaaS endpoints and databases. Omnata Sync deliver significant benefits over middleware tools:

  • Easy to use - runs natively in your Snowflake deployment with no containers

  • Plug & Play connectors - so you don't spend time building flows or scripting configs

  • No data-handling infrastructure - so it's easier to get approved by cyber-security

  • Lower cost - free yourself uncertain ‘pay per row’ integration pricing models

Ingest unlimited data as often as you need

Omnata's native app architecture is the simplest and easiest way to ingest into Snowflake. Omnata's plug & play connectors require no complex config, and automate the many edge cases of data replication.

In addition, because Omnata doesn't process your data in its own cloud instance they pass on the savings to customers in the way of flat, unlimited usage pricing. A game-changer in a world of SaaS integrators that charge you by the record.

Supports all Business Central Endpoints

With a long legacy in the ERP space, Business Central has evolved over the years and many customers have years to decades worth of data. Omnata supports the three best practice patterns to extract data from BC:

  • Standard APIs - v2.0

  • Custom APIs - also known as 'Advanced APIs' in the Power suite.

  • OData

With these three endpoints, customers can extract all their current and historical data.

Omnata is trusted by Jade Software with Business Central as a critical source

After running into some challenges with existing SaaS integration tools, James Graham, the head of analytics at Jade, decided to pivot to use Omnata. Ultimately, an agile, three-way partnership between Omnata, Data Engineers and the team at Jade turned the project around to a success. Omnata is used to ingest ERP data from Microsoft Dynamics.

Read the full case study→

Get started with the BC plugin today

For a 30-day free trial, visit the marketplace and install into your Snowflake account in minutes.

https://app.snowflake.com/marketplace/listing/GZSUZ13JOKSK/omnata-omnata-microsoft-dynamics-365-business-central

Got more questions?

Get in touch with us for a chat.

Omnata has just released its connector for Microsoft Dynamics 365 Business Central.

You can use this plugin, you can ingest data from your Business Central organisation, across all of your companies.

About Omnata Sync

Omnata Sync is a first of its kind native integration app for Snowflake that enables customers to sync data to and from SaaS endpoints and databases. Omnata Sync deliver significant benefits over middleware tools:

  • Easy to use - runs natively in your Snowflake deployment with no containers

  • Plug & Play connectors - so you don't spend time building flows or scripting configs

  • No data-handling infrastructure - so it's easier to get approved by cyber-security

  • Lower cost - free yourself uncertain ‘pay per row’ integration pricing models

Ingest unlimited data as often as you need

Omnata's native app architecture is the simplest and easiest way to ingest into Snowflake. Omnata's plug & play connectors require no complex config, and automate the many edge cases of data replication.

In addition, because Omnata doesn't process your data in its own cloud instance they pass on the savings to customers in the way of flat, unlimited usage pricing. A game-changer in a world of SaaS integrators that charge you by the record.

Supports all Business Central Endpoints

With a long legacy in the ERP space, Business Central has evolved over the years and many customers have years to decades worth of data. Omnata supports the three best practice patterns to extract data from BC:

  • Standard APIs - v2.0

  • Custom APIs - also known as 'Advanced APIs' in the Power suite.

  • OData

With these three endpoints, customers can extract all their current and historical data.

Omnata is trusted by Jade Software with Business Central as a critical source

After running into some challenges with existing SaaS integration tools, James Graham, the head of analytics at Jade, decided to pivot to use Omnata. Ultimately, an agile, three-way partnership between Omnata, Data Engineers and the team at Jade turned the project around to a success. Omnata is used to ingest ERP data from Microsoft Dynamics.

Read the full case study→

Get started with the BC plugin today

For a 30-day free trial, visit the marketplace and install into your Snowflake account in minutes.

https://app.snowflake.com/marketplace/listing/GZSUZ13JOKSK/omnata-omnata-microsoft-dynamics-365-business-central

Got more questions?

Get in touch with us for a chat.

subscribe

Deliver the goods to your inbox

subscribe

Deliver the goods to your inbox

subscribe

Deliver the goods to your inbox