Best Practice Configuration

<< Click to Display Table of Contents >>

Raynet One Data Hub > 14.0 > Connectors > Alphabetic Connector List > Google Cloud SQL Administration > Prerequisites 

Best Practice Configuration

Step-by-step implementation instructions:

Create the required credentials (see below).

Add the credentials to the connector and execute it.

Add the extracted data to the data processing and push it to applications.

 

Create the JSON Key File

In order to use the connector it is necessary to create a service account in order to receive a JSON key file.

 

A service account and the service account key can be created by executing the following steps:

 

Go to the Create service account page.

Select the target project.

Enter a descriptive name into the Service account name field and enter a description into the Service account description field.

Click on the Create and continue button.

Select a role with the necessary permissions from the Select a role list  under Project > Owner to grant the necessary rights to the service account that is used.
It is possible to assign multiple roles by clicking on the + Add another role button.

Click on the Continue button.

Click on the Done button to finalize the creation of the service account.

Click on the email address of the newly created service account.

Click on Keys.

Click Add key and then click on the Create new key button.

Click on the Create button to create and download the JSON key file.

Click on the Close button.

 

The newly created JSON key file contains all the information that is needed to setup the connector.