vaolz.blogg.se

Connect using the server information for your Connect Cloud instance (server address, port, username, and password). If you need to work with data from a custom SQL query, you can use the MySQL Connector.

Optional: Connect with the MySQL Connector

Select a visualization style and add it to the report.If needed, modify columns, click Create Report, and add the data source to the report.Use your instance name ( myinstance in ), username, and password to connect to your Connect Cloud instance.Authorize the Connector to connect to an external service (your Connect Cloud instance).Log into Google Data Studio, click data sources, create a new data source, and choose CData Connect Cloud Connector.The steps below outline connecting to CData Connect Cloud from Google Data Studio to create a new SAP HANA data source and build a simple visualization from the data. Visualize Live SAP HANA Data in Google Data Studio With the virtual database created, you are ready to connect to SAP HANA data from Google Data Studio. Click Privileges -> Add and add the new user (or an existing user) with the appropriate permissions.Set the User and the Password properties to authenticate to the server. Set the Server, Database and Port properties to specify the address of your SAP Hana database to interact with. Select "SAP HANA" from Available Data Sources.Įnter the necessary authentication properties to connect to SAP HANA.Log into Connect Cloud and click Databases.

Connect to SAP HANA from Connect CloudĬData Connect Cloud uses a straightforward, point-and-click interface to connect to data sources and generate APIs. Get more information on the CData Connect Cloud and sign up for a free trial at. This article requires a CData Connect Cloud instance and the CData Connect Cloud Connector for Google Data Studio.