Name: DataChannel
Brand: DataChannel
Rating: 4.8 (63 reviews)

Integrate Microsoft SharePoint with Google BigQuery in minutes

Enter your Microsoft SharePoint credentials

Select a predefined report or specific data to extract from

Select Google BigQuery as your target and start loading your data

What our clients say

Learn how leading e-commerce companies are leveraging data to grow their business without spending valuable hours writing ETL scripts

Stars - Elements Webflow Library - BRIX Templates

"DataChannel is flexible and scalable. It has everything we need, from granular control over data we are integrating to a quick turnaround time by the support team."

Puneet Tripathi

Head of Analytics @ Wakefit

"DataChannel has greatly improved our ability to access data reliably that was previously challenging to obtain."

Melvin Davis Vallully

Head of Data Analytics @ Wow Skin Science

"DataChannel has helped us gain access to real-time data quickly, helping us smoothen out the bottlenecks faced while analyzing data."

Minu Margeret

Founder & CEO @ BlissClub

Why choose DataChannel for your Microsoft SharePoint and Google BigQuery data integration

Granular control over pipeline configuration

Advanced scheduling options

Automated handling of source schema changes

Secure credential management with OAuth2

Activity & change history tracking

Real time alerts & failure notifications

Preview data without ever leaving the platform

Extensive documentation & on-screen help

Extensive Logs & complete visibility of pipeline health

About Microsoft SharePoint

Microsoft SharePoint Connector enables streaming Microsoft SharePoint data into a user determined warehouse through DataChannel dashboard. This sync happens in an automated manner after a user has configured relevant pipelines and determined an update frequency. You can transfer data in CSV, JSON and EXCEL formats.

Choose what data you would like to move from Microsoft SharePoint

CSV

This pipeline can be used to request and retrieve CSV files/folders (consisting similar structured CSV files). The transfer is enabled irrespective of whether CSV files are compressed or not.

Excel

This pipeline can be used to request and retrieve Excel files/folders (consisting similar structured Excel files). The transfer is enabled irrespective of whether Excel files are compressed or not.

JSON

This pipeline can be used to request and retrieve JSON files/folders (consisting similar structured JSON files). The transfer is enabled irrespective of whether JSON files are compressed or not.

Steps to Integrate Microsoft SharePoint with Google BigQuery using DataChannel

From the DataSources section select Microsoft SharePoint as the data source.
Select your added Google BigQuery data warehouse as the data destination. If you have not yet added a data warehouse, go to Data Warehouse tab and add a warehouse.
Authorize DataChannel to connect to your Microsoft SharePoint account by providing your site name and then logging into your account, similar to the process described in this Documentation page.
Click on + Data Pipeline to start adding data pipelines to your account.