Omnata SQL Server Plugin

## About the SQL-Server Plugin

This plugin, used with the [Omnata Sync Engine](https://app.snowflake.com/marketplace/listing/GZSUZ13JOEUG/omnata-omnata-sync-engine), enables you to connect to and ingest data from SQL Server databases deployed in the cloud and on-premise.

**SQL-Server plugin features:**

• Connect using Privatelink, Direct or ngrok tunnel

• Use CDC, CT, or incremental high-watermark & full-refresh syncs

• Configure and schedule multiple sync jobs to optimize performance

• Live-query functions for Snowflake worksheets and notebooks (UDFs)

**Coming soon...**

• Sync reconciliations

• Outbound syncs

<p><br/></p>

## About Omnata

Omnata is a bi-directional integration app for syncing data to and from SaaS endpoints and databases.

Omnata runs inside your account leveraging external access to connect directly to endpoints, with no data copied or stored in external infrastructure.

**Value of our approach**

• Lower the cost of integration with no data volume charges

• Simplify your integration architecture with one app for both sync-directions

• A superior architecture for cyber-security conscious customers

<p><br/></p>

## Connection methods

**Privatelink**<br/>• Snowflake Business Critical Edition accounts in AWS or Azure can now use Privatelink. This replaces the need for Omnata's in-built tunnels.

• Privatelink can be used to connect to cloud, VM or on-premise hosted databases. [View our docs.](https://docs.omnata.com/omnata-product-documentation/omnata-sync-for-snowflake/apps/microsoft-sql-server#privatelink)

**Omnata-ngrok tunnel (optional)**

• We enable you to connect to cloud and on-premise databases via secure tunnelling agent so you don't need to open network firewalls

• No data is copied or stored outside of Snowflake

• Extra billing events will apply at $3/day

• Unlimited connections and 1TB/m of data transfer (contact us if you have more than this)

**Direct**

• If your database can be made publicly accessible, you can connect directly to it using credentials.

<p><br/></p>

**To get started with Omnata:**

1. Install the [Omnata Sync Engine](https://app.snowflake.com/marketplace/listing/GZSUZ13JOEUG/omnata-omnata-sync-engine)
2. Install the Omnata Plugin for each endpoint you want to connect to

Microsoft SQL Server is a Database tier paid plugin built, maintained and supported by Omnata.

The product UI will step you through app installation, connecting to your app and creating syncs. You can also [visit our docs](https://docs.omnata.com/omnata-product-documentation/omnata-sync-for-snowflake/step-by-step-guides) for a step-by-step guide.

**Availability**

This plugin is General Available in all regions.

搜集汇总

背景与挑战

背景概述

该插件与Omnata Sync Engine配合使用，支持从云端和本地SQL Server数据库提取数据，提供私有链接、隧道等多种连接方式，以及CDC、增量同步等功能。它旨在通过简化集成架构、降低成本和提升安全性来优化数据同步体验。