Microsoft SQL Server 2008 database

Looker Q&A Looker Studio
1

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.

2

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.

3

@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