Connect google bigquery to SQL Server with SSIS

Question

Hi All,

I need to load data to our SQL Server 2012 From google bigquery. I would like to do it with SSIS.

What is the best way to connect to google bigquery through SSIS?

Thanks!

Answer 1

 RSSBus ADO.NET Data Providers to connect SQL Server directly with remote data via SSIS.

St 1: Open Visual Studio and create a new Integration Services Project.
St 2: Add a new Data Flow Task from the Toolbox onto the Control Flow screen.
St 3: In the Data Flow screen, add a DataReader Source and an OLE DB Destination from the Toolbox.

St 4: Add a new Data Connection, and select your provider as .NET Providers\RSSBus QuickBooks Data Provider.
St 5: Enter the connection details for your QuickBooks machine. In this example, we are using a separate machine to host QuickBooks on.

St 6: Open the DataReader editor. Go to the Connection Managers tab and select the Data Connection you just created.
St 7: Keeping the DataReader Source open, go to the Component Properties tab and enter your SQL select command.

St 8: Close the DataReader editor. Now drag the arrow below the DataReader Source to connect it to the OLE DB Destination.
St 9: Open the OLE DB Destination and add a New Connection. Enter your server and database information here. In this example, we are using a separate machine running SQLExpress.
St 10: Set your Data access mode to "table or view" and select the table or view to populate in your database
St 11: Configure any properties you wish to on the Mappings screen.

St 12: Close the OLE DB Destination Editor and run the project. After the SSIS Task has finished executing, your database will be populated with data obtained from QuickBooks

https://www.rssbus.com/kb/articles/ado-ssistask.rst

---

Vote As Helpful if it helps to solve your issue

Answer 2

Hi Avi_Bit,

Since there is no build-in provider that can access data from Google BigQuery, we can use the custom SSIS Data Flow Source & Destination for Google BigQuery to connect and synchronize SQL Server with Google BigQuery data. For more details about it, please see:
https://visualstudiogallery.msdn.microsoft.com/52034498-6cf4-4c12-b560-e3712962ec58

To download the component, please go to there:
http://www.cdata.com/drivers/bigquery/ssis/

Thanks,
Katherine Xiong

---

Katherine Xiong
TechNet Community Support

Answer 3

I have solve this using cdata and ssis 2012.Its easily connected with google big query.

Answer 4

You may also check the commercial COZYROC Google BigQuery connection.

---

SSIS Tasks Components Scripts Services | http://wwww.cozyroc.com/

Answer 5

Google has an "Official" ODBC driver that works with SSIS.

https://cloud.google.com/bigquery/providers/simba-drivers