Demandbase Data Stream Overview

Demandbase Data Stream is a customer data delivery service that automatically delivers Demandbase data daily to your cloud data warehouse or cloud storage environment. You can use this data with business intelligence (BI) tools such as Domo, Tableau, and Power BI.

Data Stream eliminates manual data exports and imports, reduces the risk of missing data, and improves data consistency. It supports automated delivery of tens of millions of rows, providing reliable access to Demandbase data for reporting and analysis.

Important: Data Stream supports cloud data warehouses and cloud storage services only. If your organization uses an on-premises data center, contact your Demandbase Account Team to discuss potential options.

Benefits of Data Stream

Data Stream enables you to combine Demandbase data with other data sources for advanced analytics, reporting, and business intelligence.

Centralize data and reporting: Combine Demandbase data with other sources to create dashboards and gain a comprehensive view of business performance.
Generate customer and campaign insights: Identify trends, measure campaign effectiveness, and uncover growth opportunities.
Improve targeting and campaign execution: Use data insights to refine account lists and optimize marketing campaigns.
Optimize keywords and engagement: Identify high-performing keywords to improve targeting, engagement, and return on investment (ROI).
Support advanced analytics: Use Demandbase data for data science, machine learning, and business intelligence initiatives.

Who Uses Data Stream?

Data Stream is designed for teams that use Demandbase data to build custom dashboards, perform advanced analysis, and develop machine learning models.

Common users include:

Data analysts: Use SQL, Excel, and BI tools such as Tableau to analyze data and build dashboards that support business decisions.
Analytics and BI teams: Create dashboards and reports for marketing, sales, and other business teams.
Data engineers and data scientists: Perform extract, transform, and load (ETL) processes and advanced analysis using technologies such as Spark and Hadoop.
Marketing operations teams: Combine Demandbase data with other marketing and sales data to measure performance and improve campaign execution.

Data Availability by Collection

The data available through Data Stream depends on the Collections your organization purchases.

Each Collection provides access to datasets for specific business needs, such as data modeling, activation, reporting, and visualization.

See Data Stream Collections.

Data Delivery Schedule

Demandbase delivers Data Stream data daily at 12 PM UTC, including weekends.

Each delivery includes data available through 5 AM UTC on the same day.

Because Data Stream processes data once daily, the delivered data may differ from data displayed in Demandbase One later in the day. Changes that occur after the daily cutoff are reflected in a subsequent delivery.

Data Stream uses a fixed daily delivery schedule to maintain data completeness and consistency. Custom delivery schedules are not currently supported.

Data Stream Access Methods

Data Stream offers two access methods: Delivery and Hosted. Choose the method that best fits your organization's infrastructure and data requirements.

Delivery Method

The Delivery method sends Demandbase data directly to your organization's cloud environment. Your organization controls data retention, access permissions, and other data management policies.

Supported Delivery Destinations

Cloud data warehouses:
- Google BigQuery.
- Amazon Redshift.
Cloud storage services:
- Google Cloud Storage (GCS).
- Amazon S3.
- Microsoft Azure Blob Storage (via Azure Data Share).
- Demandbase-hosted SFTP.

Delivery Formats

The delivery format depends on the destination:

Cloud data warehouses: Partitioned tables organized by delivery date.
Cloud storage: Apache Parquet files organized by delivery date.
CSV: Available upon request.

Apache Parquet is the default format for cloud storage deliveries.

Delivery Setup

Demandbase works with your technical team to configure delivery to your designated destination, such as a BigQuery dataset or Amazon S3 bucket.

For supported destinations, setup and initial delivery can typically be completed within one day.

Important: Each Data Stream configuration supports only one delivery destination.

Hosted Method

The Hosted method allows you to access data stored and managed by Demandbase in Google Cloud Platform (GCP) or on a Demandbase-hosted SFTP server.

Demandbase provides isolated access to customer data through dedicated BigQuery datasets or GCS buckets.

Hosted Access Options

BigQuery API: Access data through scheduled batch queries. Recommended for BI tools such as Domo, Tableau, and Power BI.
GCS API: Retrieve raw data files in Apache Parquet format.
SFTP: Access data files directly through Secure Shell (SSH).

Hosted Setup

Access requirements depend on the hosted option:

Google Cloud Platform: Use a Google user account or service account. Each integration supports one account. Contact Demandbase to switch or suspend an account.
SFTP: Provide a designated technical contact to coordinate SSH access.

Demandbase works with your technical team to configure access to the hosted environment.