Omnata is a product company following a native app strategy. Before the Snowflake Marketplace existed, our 5-star rated integration native app on the Salesforce AppExchange is in production at enterprise customers around the world.

We joined the Snowflake Native App program early in its life and have architected a robust and reliable app, while pioneering the use of Snowflake’s underlying platform features. Co-founder & CEO James Weakley is a Snowflake Data Superhero, an early Snowflake customer and original author of widely use open source tools like Snoad and Schema change.

Bi-directional syncs

Why do ‘modern data stack’ vendors tell you to buy one tool to ingest data, ELT, and another to output it, Reverse-ETL?

We never understood it… so we built Omnata Sync right the first time with bi-directional sync capabilities.

At the beginning of a Snowflake customer’s journey, they need to get data into the platform. Once they clean, model and generate insights, they inevitably end up using those insights downstream in the same or other applications and workspaces.

Omnata can enable the full lifecycle of analytics from discovery to activation.

Use case: CRM data enrichment

CRM data enrichment is a solution that can now be deployed 100% on Snowflake without any external services. Previously this would have required point-to-point API integration to an external SaaS.

With native apps and data-sharing:

1. Data is ingested from Salesforce (or another CRM) via Omnata.

2. A third-party dataset, like People Data Labs (below), is acquired through the Snowflake Marketplace.

3. Using SQL or your preferred method, raw data is cleansed and joined to the enrichment dataset.

4. The enriched output table is synced back to update the Salesforce record.

Omnata sync can run on a 1-minute latency loop so CRM users get near-real-time feedback on their actions.

Scalable architecture to manage all your connections and syncs

Omnata’s native app architecture separates the sync operations and the connectors to enable scalable integration management for enterprises.

The Omnata Sync Engine, a free listing, contains the core data sync logic, administration and integrations. The Plugins are the connectors to each end-point.

This architecture enables us to run rapid release cycles on plugin improvements, simplify billing events and allow for custom plugins to be built and installed.

Omnata’s UI contains useful overviews of syncs, sync runs and record activities. No scripting, commands or SQL-queries are required to understand the state of play. This simplifies the hand-off to your colleagues in the data team and beyond.

Rich administration tools to monitor and debug syncs

Standalone middleware tools must discard data for cyber-security reasons.

Since Omnata runs inside your Snowflake account, it can keep a full history of sync activity down to the record-level. You can search and filter the entire history of a record from ingest to activation, safely within the app database.

Git-style change management

Never break a data pipeline again.

Omnata has built-in version control called Branching Mode. Enabling branching, you can modify sync configs and test them before merging onto the main branch.

Branching mode facilitates sync testing across varying environment types, whether it’s a completely separate instance or just a test area, like a dummy object or record.

Configure and orchestrate with dbt

Following on from branching mode, Omnata’s dbt integration enables analytics-engineers to configure and deploy sync runs using dbt Cloud and Core. Branching mode with dbt enables you to test sync config changes and promote to production with a single git-merge.

Using the dbt integration, you can orchestrate the end-to-end pipeline from your dbt workflow; starting at data ingestion, transformation, then activation.

Custom plugins

Omnata’s plugin framework is open for developers to quickly build connectors to custom endpoints.

Our Python-based dev kit handles the undifferentiated heavy lifting of building an ELT connector and reduces the time to deliver by 80%. A notebook style workspace automates test cases, pre-configures UX form fields and provides fine-grained control over sync strategies and rate-limiting. Plugins can be securely uploaded to your account without any external SaaS service.

Try Omnata today for 30-day from the Snowflake Marketplace

Visit the Marketplace or get in touch with us.