This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Log in to ask a question

Microsoft SQL Server 2008 database

Posted on 10-31-2024 02:09 AM
Achala_Fcpl
Bronze 4
Bronze 4
Reply posted on --/--/---- --:-- AM

Hi Everyone, 

I'm trying to connect my Microsoft SQL Server 2008 database to Looker Studio. However, I've noticed that Looker Studio officially supports only SQL Server versions 2012 and above.

I'm wondering if there are any workarounds or alternative approaches to connect my older SQL Server 2008 database to Looker Studio.

 

 

0 2 119
Topic Labels
0 Likes
2 REPLIES 2

Posted on --/--/---- --:-- AM
sam8
Staff
Reply posted on --/--/---- --:-- AM

I think your best bet is to either upgrade the database, if possible, or extract the data into a newer database!

I don't know of any workarounds to connect Looker Studio to SQL Server 2008 and I don't think new workarounds are likely to surface as time goes on.

0 Likes

Posted on --/--/---- --:-- AM
ArkadyZagdan
Silver 3
Silver 3
Reply posted on --/--/---- --:-- AM

@Achala_Fcpl 
Consider a data replication process into BigQuery warehouse and then connect to Looker Studio.
In BigQuery you can work with your data using legacy SQL dialect also. 
It will also increase your data tranformation abilities, advantage of using custom queries and will greattly improve how quick your dashboards work.

Regards
Arkady Zagdan

0 Likes