Getting Started - Overview

Overview for setting up a private, secure data pipeline

Openbridge Support avatar
Written by Openbridge Support
Updated over a week ago

Welcome to this friendly guide! We will take you through an easy, step-by-step process to set up your account and get your automated flow of data up and running.

A Quick Peek at the Process

To make the most of Openbridge, you'll need an account, a data destination (think of it as a storage place), and a data source (this is where the data you'll be collecting comes from). To start, you'll need one destination and one source to create a 'pipeline.' For example, imagine Snowflake as your cloud data warehouse (destination) and Amazon Advertising as your data source. Put these two together; voila, you have a data pipeline (Amazon Ads -> Snowflake).

Why the Need for a Cloud Warehouse or Data Lake Destination?

With the amount and complexity of data increasing over time, a proper system is required. A robust storage system helps reduce risks related to source system data structures, formats, and scale changes.

But, no need to worry! Modern solutions are not only cost-effective and easy to set up, but they also enhance the productivity and speed of tools like Tableau, Power BI, Looker, Data Studio, Data Factory, QuickSight, and many others.

Let's Get Started

Setting up your data pipeline can be as quick as brewing a cup of coffee:

  1. Create an account: Kick off your journey with Openbridge by signing up for a 30-day, absolutely free trial. It's a no-risk way to dip your toes in.

  2. Connect a destination: This is where Openbridge will deliver your data. We're compatible with industry leaders like Amazon Redshift, Amazon S3 data lake, Azure data lake, Snowflake, Google BigQuery, Ahana, and Amazon Athena.

  3. Connect a source: This is where Openbridge gets your data from. Some examples could be Google Ads, Facebook Marketing, Amazon Selling Partner, Amazon Advertising, etc.

  4. Save your pipeline: Once your source and destination are linked, save your pipeline. And you're all set! Your data will begin to flow between the two systems.

Keep in mind that setting up your pipeline may take 24 to 48 hours for the initial automated sync to happen. The timing depends on the upstream data source, which has various limits, throttles, and constraints. But don't worry; Openbridge automatically optimizes the sync rates based on the source API, data availability, errors, and outages.

My Data is Flowing and Unified; What's Next?

Once your data is organized and optimized, the world is your oyster. There are numerous possibilities for you to explore, model, or report on your data. Your new unified data hub works with hundreds of business intelligence platforms, SQL editors, ETL, and data science tools.

Use analytics tools like Tableau, Microsoft Power BI, Looker, Data Studio, etc. Or, connect data processing applications like Azure Data Factory or AWS to mobilize your data further. And for custom data transformations, tools like DBT are at your disposal.

Harnessing your data effectively can turbocharge your competitive advantage, help with regulatory compliance, and fuel growth.

Excited? Ready to dive in? Sign up for your 30-day free trial today!

Did this answer your question?