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

Will Data Studio eventually support a MSSQL data connection?

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Or does it already and I'm just missing something?

 

We have a MSSQL database that we'd love to use Data Studio with, but not seeing an option to connect to it. Is there a workaround? Unfortunately migrating to MySQL is not an option.

1 Expert replyverified_user
1 ACCEPTED SOLUTION

Accepted Solutions
Marked as Best Answer.
Solution
Accepted by topic author Greg B
August 2016

Re: Will Data Studio eventually support a MSSQL data connection?

[ Edited ]
Rising Star
# 2
Rising Star

Use the Google Apps Script
JDBC Service (https://developers.google.com/apps-script/guides/jdbc) to connect your database to Google Sheets, and then to Data Studio.

There are also paid commercial services such as dataeverywhere.com for Google Sheets that already does the heavy lifting for you if your data model is not too complex.

_________________________________________________________________________
Director of Marketing | Nehmedia | Partner Profile

View solution in original post

Marked as Best Answer.
Solution
Accepted by topic author Greg B
August 2016

Re: Will Data Studio eventually support a MSSQL data connection?

[ Edited ]
Rising Star
# 2
Rising Star

Use the Google Apps Script
JDBC Service (https://developers.google.com/apps-script/guides/jdbc) to connect your database to Google Sheets, and then to Data Studio.

There are also paid commercial services such as dataeverywhere.com for Google Sheets that already does the heavy lifting for you if your data model is not too complex.

_________________________________________________________________________
Director of Marketing | Nehmedia | Partner Profile

Re: Will Data Studio eventually support a MSSQL data connection?

Visitor ✭ ✭ ✭
# 3
Visitor ✭ ✭ ✭
Thank you, Phillip! This might do the trick for us.

Re: Will Data Studio eventually support a MSSQL data connection?

Follower ✭ ✭ ✭
# 4
Follower ✭ ✭ ✭

Will Data Studio eventually support a MSSQL data connection?

Visitor ✭ ✭ ✭
# 5
Visitor ✭ ✭ ✭

I am new to this. But I know our DB is MSSQL, would love the ability to tie directly in. Cleaner to go directly into the DB. Love the innovation on this product though.

Going to try the suggested fix for now. Thanks Phillip B.

Will Data Studio eventually support a MSSQL data connection?

Visitor ✭ ✭ ✭
# 6
Visitor ✭ ✭ ✭

Hi,

Do you know how to make a connection with mssql?

 

var dbUrl = 'jdbc:mssql://' + address + '/' + db;

// Read up to 1000 rows of data from the table and log them.
function readFromTable() {
var conn = Jdbc.getConnection(dbUrl, user, userPwd);

Will Data Studio eventually support a MSSQL data connection?

Explorer ✭ ✭ ☆
# 7
Explorer ✭ ✭ ☆

@Greg B , with the custom connector, I am sure, we will get one very soon !!!

Will Data Studio eventually support a MSSQL data connection?

Visitor ✭ ✭ ✭
# 8
Visitor ✭ ✭ ✭

Were you ever able to make this connection? I haven't found a way yet. I can't go from mssql to sheets first because I have to many rows for sheets. Currently all my data goes into azure and I use bime for analytics but I really want to switch to data studio for the secure sharing options I get having Google apps company wide. 

Will Data Studio eventually support a MSSQL data connection?

Visitor ✭ ✭ ✭
# 9
Visitor ✭ ✭ ✭

I have a repo on GitHub that does both MySQL and MSSQL connections and imbeds the queries to the specific sheet you are working on. The connection strings for both MySQL and MSSQL are in the source code for your reference.

Link here:
https://github.com/ebarreat/Google-Spreadsheet-JDBC

 

If you have any questions please let me know!