Data Studio
6.1K members online now
6.1K members online now
Ask questions about Data Studio
Guide Me
star_border
Reply

Connect Data Studio to SQL Server?

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Is it possible to have SQL Server as a data source for Data Studio? If not, are there plans to implement this feature? What is the best solution for using Data Studio with data currently in SQL Server?

2 Expert replyverified_user
1 ACCEPTED SOLUTION

Accepted Solutions
Marked as Best Answer.
Solution
Accepted by topic author Tim M
November 2016

Connect Data Studio to SQL Server?

Top Contributor
# 3
Top Contributor

SQL Server is not supported; you have other options but they all imply some degree of database export or replication, which is not ideal.

Like @James_Clemens mentioned, BigQuery or Google Cloud SQL are available and fairly inexpensive, for storage anyway.

VP & Chief Evangelist at Hub'Scan | Contact me
Level 80 Digital Analytics Warrior, KPI Therapist and Keeper of the One True Tagging Plan

View solution in original post

Connect Data Studio to SQL Server?

Top Contributor
# 2
Top Contributor

Hi @Tim M,

 

I think you would want to give Google's BigQuery a free trial run and see if suites your needs. It is a preferred data source for Data Studio and is built for this type of action. 

 

Kind Regards,

 

James

_________________________________________________________
Google AdWords Top Contributor | Google Partner | GYBO | Local Guide | My Profile


 


 


 

Marked as Best Answer.
Solution
Accepted by topic author Tim M
November 2016

Connect Data Studio to SQL Server?

Top Contributor
# 3
Top Contributor

SQL Server is not supported; you have other options but they all imply some degree of database export or replication, which is not ideal.

Like @James_Clemens mentioned, BigQuery or Google Cloud SQL are available and fairly inexpensive, for storage anyway.

VP & Chief Evangelist at Hub'Scan | Contact me
Level 80 Digital Analytics Warrior, KPI Therapist and Keeper of the One True Tagging Plan

Connect Data Studio to SQL Server?

Visitor ✭ ✭ ✭
# 4
Visitor ✭ ✭ ✭

Thank you @James_Clemens and @Julien Coquet for the feedback. Due to the nature of our business, it's a requirement to keep our data on our own servers.

 

After looking at the other options, I believe we'll write a script to export the data we need into MySQL format nightly, and connect Data Studio to that. This will require some legwork and won't be completely real-time, but I think is the best solution for us.

 

Thanks again!

Connect Data Studio to SQL Server?

Top Contributor
# 5
Top Contributor

Another option is to wait for Google to provide an MSSQL conector but I have no ETA on that

VP & Chief Evangelist at Hub'Scan | Contact me
Level 80 Digital Analytics Warrior, KPI Therapist and Keeper of the One True Tagging Plan

Connect Data Studio to SQL Server?

Visitor ✭ ✭ ✭
# 6
Visitor ✭ ✭ ✭

Hello Julien,

Do you have some news concerning MSSQL connector to Google Data Studio ?

Thanks a lot.

Connect Data Studio to SQL Server?

Visitor ✭ ✭ ✭
# 7
Visitor ✭ ✭ ✭

Hello Julien,

Why is it not ideal to do database export or replication?

Thanks,

 

Jean-Sebastien

Connect Data Studio to SQL Server?

Visitor ✭ ✭ ✭
# 8
Visitor ✭ ✭ ✭

what about postgres?

Connect Data Studio to SQL Server?

Visitor ✭ ✭ ✭
# 9
Visitor ✭ ✭ ✭
#standardSQL
SELECT
 weight_pounds
, state, year, gestation_weeks
FROM
 
`bigquery-public-data.samples.natality`
ORDER BY weight_pounds DESC LIMIT 10;

Connect Data Studio to SQL Server?

Follower ✭ ☆ ☆
# 10
Follower ✭ ☆ ☆

Hello @Tim H check out this synch tool for SQL Server to AWS MySQL, maybe it fits what you need.

 

https://factorbi.github.io/