Omnata’s SQL Server Plugin is architected to be flexible for a wide range of use cases when pulling data into Snowflake. In this post, we’ll talk through the different sync strategies supported by Omnata and when to use them.

Recently, we added more connectivity options to Omnata sync to help you connect to databases like SQL Server, Postgres, with more on the way. If you have data on-premise, in the cloud and need the highest level of security, Omnata can help.

Omnata's secure tunnelling to your databases provides a simple and seamless way to ingest data into Snowflake, this is how we leverage ngrok to stick to our 'no middleware' design principle.