Down at Omnata HQ, we've been busy shipping new native connectors for the Omnata Snowflake Native App.

Why Omnata?

• Flat pricing; buy one for a fixed daily fee, or bundle multiple connectors on a contract. Unlimited records, syncs and refrehses.

• Native to Snowflake; skip cyber reviews, data sovereignty issues and procurement hurdles.

• Easy to use; start in minutes, click to config, rich with sync features.

We've added plugins for CRM, HR, finance, and data platforms. Here's a summary of everything that's new.

MS Excel

Everyone's got spreadsheets right?

The Omnata MS Excel Plugin connects Microsoft 365 Excel files hosted in SharePoint Online to Snowflake, bi-directionally. Inbound syncs support three modes: single file (one workbook, one stream per worksheet), multi-file (a SharePoint folder with a filename regex, one stream per file), and multi-file consolidate (same folder approach, but all matching files merged into a single stream). Outbound sync writes a Snowflake table or view back to a specified worksheet, replacing its contents on each run.

Documentation · Marketplace listing

Databricks

Have you got Databricks served up by an external provider or are you blocked from using infrastructure level solutions like Iceberg?

The Omnata Databricks Plugin replicates tables and views from Databricks into Snowflake, with support for all three cloud providers (AWS, Azure, and GCP). Incremental syncs use a high-watermark cursor column to fetch only changed records; full refresh is available for tables without a suitable cursor. Three connectivity options are supported: direct (public endpoint), PrivateLink (same cloud and region), and Omnata's secure ngrok tunnel.

Beyond scheduled syncs, the plugin exposes a SQL_QUERY table function that lets you run ad-hoc SELECT statements against your Databricks instance directly from Snowflake SQL, without pulling the data into a table first.

Documentation · Marketplace listing

BambooHR

HR data is sensitive! As a native app, Omnata does not handle your sensitive data making it a simple and secure solution for HR data replication.

The Omnata BambooHR Plugin brings employee data from BambooHR into Snowflake, covering company information, core employee records, and per-employee tabular data.

Documentation · Marketplace listing

UKG Pro

The Omnata UKG Pro Plugin pulls workforce data from UKG Pro WFM into Snowflake, currently supporting: Employees, Employment Types, Locations, Org Levels, and Pay Groups. Omnata automatically addresses UKG's system nuances, where hard-deleted employees are detected via UKG's audit log and merged into the final table, saving you from custom development. As with Bamboo HR, Omnata's native app architecture ensures no sensitive company data is handled outside of your controlled environments Snowflake and UKG itself.

Documentation · Marketplace listing

PayPal Braintree

The Omnata PayPal Braintree Plugin syncs transaction, subscription, dispute, and customer data from Braintree into Snowflake. Braintree is PayPal's enterprise payments solution, with the connector enabling revenue analytics, subscription reporting, and reconciliation workflows that benefit from having payment data sitting alongside the rest of your data platform. Customer PII is protected by Omnata's native app architecture.

Documentation · Marketplace listing

Zoho CRM

The Omnata Zoho CRM Plugin is bidirectional: it syncs Zoho CRM records into Snowflake for analysis, and pushes enriched data back to Zoho for sales teams to act on. Bundle the Zoho plugin with the rest of your CRM and Marketing stack tools.

Documentation · Marketplace listing

QuestDB (time-series database)

The Omnata QuestDB Plugin replicates time-series data from QuestDB into Snowflake, with support for direct, ngrok and PrivateLink connections. It is well suited to industrial and operational use cases where QuestDB is used as a high-throughput time-series store, such as the backend for SCADA and monitoring systems like Inductive Automation's Ignition. The plugin fetches data in batch and can handle large scale data.

Documentation · Marketplace listing

Netsuite (coming soon)

Omnata will pull your ERIP data directly into Snowflake. Stay tuned.

Get started

All plugins run as Snowflake Native Apps and require Omnata Sync (free core listing) installed in your Snowflake account. Most are available on the Snowflake Marketplace with a 30-day free trial. You can pay for Omnata using Snowflake Credits (if in an eligible region).

Browse all Omnata plugins