We are looking to connect one of our advertising platform to Data Studio via a Connector. We have all of the information needed from our platform, such as the API Key, however we do not have experience connecting this to Data Studio.
It is as simple as you link the Connector to your Data Studio. I have the Connector termplate so you could modify based on your API. Modifiy the oAuth2 part, once connected you modify the sql function part and then wrap into JSON-based format. That's simple.
Hi
Our preferred approach is to stream data via API from SaaS to BigQuery tables. Data Studio can build any reports from BQ tables. In this scenario there is no need for a custom build connector.
We deploy the streaming software in Google Dataflow. We find this approach simpler, cleaner and easier to maintain or extend. Also data streaming maintains full history of data changes over time.
Would you be interested to have a streaming pipeline instead of a custom connector?
Please contact me if you have any question.