In this guide, we will describe the quick and simple process to get of activating an account and getting an automated flow of data operational.
Overview
To use Openbridge, you need an account, a data destination and a data source you want to collect data from. At a minimum, you need at least one data destination and data source to create a pipeline. For example, Snowflake as a cloud data warehouse destination, and Amazon Advertising source data delivered to this destination. Combined, these two create a data pipeline (Amazon Ads -> Snowflake).
Why do we require a cloud warehouse or data lake destination? Due to the volume and complexity of the data over time, a system is needed. Storing data in an actual system reduces risks associated with changes in source system data structures, formats, and scale.
Don't be intimidated, though; modern solutions are cost-effective, fully managed, and easy to set up. They also supercharge the productivity and speed of tools like Tableau, Power BI, Looker, Data Studio, Data Factory, QuickSight, and many others.
Getting Started
In just a few minutes, you can set up your data pipeline:
Sign up for an Openbridge account: Sign up for a 14-day, no cost, risk free trial.
Connect a destination: A destination, typically a data lake or cloud warehouse, is where Openbridge will land your data. We support industry leaders like Amazon Redshift, Amazon S3 data lake, Azure data lake, Snowflake, Google BigQuery, Ahana, and Amazon Athena.
Connect a source: A data source is a point of origin Openbridge collects, routes, and processes data. For example, a data source like Google Ads, Facebook Marketing, Amazon Selling Partner, Amazon Advertising, and many others.
Save your pipeline: Once you have connected your source and destination, save your pipeline. That's it! Data will start to flow between the two systems.
Upon completing your pipeline configuration, it can take 24-48 for the initial automated sync(s) to occur. The timing is a function of the upstream data source as each has various limits, throttles, and constraints. Openbridge optimizes the sync rates automatically based on the source API, data availability, errors, and outages.
My data is automated and unified; now what?
With data unified and optimized, you will want to do some exploring, modeling, or reporting. You have many options if you're going to create visualizations, reports, undertake ETL, or run SQL queries. Your new unified data hub is compatible with hundreds business intelligence platforms, SQL editors, ETL, and data science tools.
You can leverage industry-leading analytics tools like Tableau, Microsoft Power BI, Looker, Data Studio, and many others. You can also connect data processing applications like Azure Data Factory or AWS for further data mobilization to other systems. Lastly, you can use tools like DBT for custom data transformations.
Unlocking data allows you to turbocharge the use of data for competitive advantage, regulatory compliance, ownership, and growth.
Ready to get started? Sign up for a 14-day free trial.