Two powerful tools, together

Integrate Close and Power BI to turn your data into actionable insights.

About Close

Close is a sales communication platform.


Stitch offers detailed documentation on how to sync all your Close data today.

Stitch Close Documentation

About Power BI

Power BI is a cloud-based platform for creating and sharing real-time data visualizations. It features templates for popular data sources and drag-and-drop capabilities for building charts. Users can create reports, dashboards, and visualizations without having to rely on IT staff.

Learn more about Power BI

Stitch makes it easy to get data into Power BI.

Instead of spending time extracting data from Close and sending it to Power BI manually, Stitch automates the process. Here's how:

Data flowing out of Close

Connect Close to Stitch

Quickly connect your Close account to Stitch, choose your data, and replicate on a schedule you define.

Data flowing through Stitch logo

Send your data to the leading warehouses

Stitch delivers your data to the analytics warehouse of your choice. Don't have a warehouse yet? No problem. Stitch can provision one for you.

Data flowing into an analytics warehouse

Connect your warehouse to Power BI

In most cases, it's simply a matter of providing access credentials. Follow this step-by-step tutorial for connecting Power BI to your warehouse.

See the Power BI Tutorial
Data flowing into Power BI

Expected Close data

Here’s a sample of the raw Close data that Stitch will replicate to your analytics warehouse:

Leads

The leads table contains information about the leads in your Close account. Attributes include the lead ID (id), status ID, status label, display name, name, addresses, URL, created by, organization ID, updated by, description, and created at and updated at dates. Our integration will also detect and load any custom fields you’ve created for leads.

Integrations Table Icon Table name: closeio_leads

Activities

The activities table contains information about the activities performed on a lead or its contacts. Attributes include the activity ID (id), type, user ID, user name, created/updated by, created/updated by name, organization ID, source, contact ID, lead ID, and date updated.

Integrations Table Icon Table name: closeio_activities

View all tables

Close to your data warehouse in minutes

Stitch delivers all your data to the leading data lakes, warehouses, and storage platforms.

Stitch helped us get important data into Redshift easily.

Brendan Hastings

Senior Director, Engineering and Digital Product, Thinx

Why our customers choose Stitch

Stitch is a simple, powerful ETL service built for developers. Stitch connects to your first-party data sources – from databases like MongoDB and MySQL, to SaaS tools like Salesforce and Zendesk – and replicates that data to your warehouse. With Stitch, developers can provision data for their internal users in minutes, not weeks.

Explore all of Stitch's features
Simple Integrations Icon Simple setup
Start replicating data in minutes, and never worry about ETL maintenance.
Integration Infrastructure Icon Own your own data infrastructure
Stitch replicates to your warehouse, meaning you’re always in control.
Replication Features Icon Mature replication engine
Accurate data from any structure, all the time.
Explore all of Stitch's features

Connect to your ecosystem of data sources

Stitch integrates with leading databases and SaaS products. No API maintenance, ever, while you maintain full control over replication behavior.