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

Connect to data sources dynamically

[ Edited ]
Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Hi ,

I am building custom report for an organisation.

While development I will be connecting to sample data sources.

But as soon as the reports are ready I want to deploy them into live/production environment.

So how can I connect to live data sources dynamically without having to change it manually in the reports ?

Is there any API available to interact with data studio ?

 

Thanks & Regards,

Arbaz Pathan

1 Expert replyverified_user

Connect to data sources dynamically

Top Contributor
# 2
Top Contributor

Hi there, 

SQL server data source is not available yet. 

See other related topic:

https://www.en.advertisercommunity.com/t5/Data-Studio/Hey-guys-I-know-Data-Studio-connects-to-MySQL-...

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

Connect to data sources dynamically

[ Edited ]
Visitor ✭ ✭ ✭
# 3
Visitor ✭ ✭ ✭

Hi Julien,

I am aware of this , suppose for e.g. my data source is bigquery . So while developing I connected to bigquery development database. But after testing I want to switch the connection to my bigquery live database. Switch without having to manually change it from within the report.

 

Thanks & Regards,

Arbaz Pathan

Connect to data sources dynamically

Top Contributor
# 4
Top Contributor

That won't work, you'll need to change the data source for the widget

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

Connect to data sources dynamically

Top Contributor
# 5
Top Contributor

if you want to go that route, you're better off populating a Google Sheet with your SQL/BQ connector and use that as a datasource in DS

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