Google Cloud SQL (SQLServer)
Nexla's bi-directional connectors can both send data to and receive data from any data system. This means that once a user has created or gained access to a credential for any data system, building any data flow to ingest data from or send data to a location within that data system requires only a few simple steps.
Three Google Cloud SQL connectors are available in Nexla, allowing users to connect to any Cloud SQL instance. This page provides instructions for using the Google Cloud SQL SQLServer connector for instances of Cloud SQL used with SQL Server databases.
To connect to a different type of Google Cloud SQL instance, see Google Cloud SQL (MySQL) or Google Cloud SQL (PostgreSQL).
1. Credentials
This section provides information about and step-by-step instructions for creating a new Google Cloud SQL MySQL credential in Nexla.
1.1 Add a New Google Cloud SQL SQLServer Credential
After selecting the data source/destination type, in the screen, click . This will open the Add New Credential window.
Enter a name for the credential in the Credential Name field.
Optional: Enter a description for the credential in the Credential Description field.
Enter the hostname of the database in the Host field.
The hostname should be an IP Address or text in the format
company.domain.com
.Do not include the connection protocol.
Enter the port that Nexla should use to connect to Cloud SQL in the Port field.
Enter the username associated with the Cloud SQL account in the Username field.
Enter the password for the username entered in Step 5 in the Password field.
Enter the name of the database in the Database Name field.
Section 1.2 provides information about advanced settings available for Google Cloud SQL MySQL credentials along with step-by-step instructions for configuring each setting.
To configure any desired additional advanced settings for this credential, continue to Section 1.2, and complete the relevant steps.
To create this credential without configuring any advanced settings, continue to Section 1.3.
1.2 Advanced Settings
This section covers optional advanced credential settings. To create the Cloud SQL credential without configuring advanced settings, skip to Section 1.3.
Click at the bottom of the Add New Credential window to access additional available settings for the Google Cloud SQL MySQL credential.
Database Schema Name
If the database tables that will be accessed with this credential use a schema, enter the name of the schema in the Schema Name field.
Access Google Cloud SQL via an SSH Tunnel
If the database from which data should be read with this credential is not publicly accessible, check the box next to . This will append additional related fields to be populated in the Add New Credential window.
Selecting this option allows Nexla to connect to a bastion host via SSH, and the database connection will then be provided through the SSH host.
Enter the SSH tunnel hostname or IP address of the bastion host running the SSH tunnel server that has access to the database in the SSH Tunnel Host field.
Enter the port of the tunnel bastion host to which Nexla will connect in the SSH Tunnel Port field.
Create an SSH username for Nexla in the bastion host, and enter that username in the Username for Tunnel field.
Usually, the username is set as "nexla".
Database Connectivity Restriction
The database connectivity capabilities available when using this credential can be restricted by specifying the connection mode for the credential.
To restrict database connectivity to a specific mode, select the desired mode from the Connection Mode/Application Intent pulldown menu.
- Read Write – This is the default connectivity mode for a Google Cloud SQL SQLServer credential. It grants both read and write capabilities to users who connect to Cloud SQL using this credential.
- Read Only – Select this connectivity mode to grand read-only access to users who connect to Cloud SQL using this credential.
1.3 Save and Create the Google Cloud SQL MySQL Credential
Once all of the relevant steps in the above sections have been completed, click at the bottom of the Add New Credential screen to save the credential and all entered information.
The newly added credential will now appear in a tile on the screen and can be selected for use with a new data source or destination.
2. Data Source
To ingest data from a Google Cloud SQL location, follow the instructions in Section 2 of Common Setup for Databases & Data Warehouses.
3. Data Destination
To send data to a Google Cloud SQL location, follow the instructions in Section 3 of Common Setup for Databases & Data Warehouses.