Google Cloud SQL Spoke

Mange provisioning of MySQL and PostgreSQL in Google Cloud SQL from your ServiceNow instance.

Request apps on the Store

Visit the ServiceNow Store to view all the available apps, and for information about submitting requests to the store. For cumulative release notes information for all released apps, see the ServiceNow Store version history release notes.

Integration Hub subscription

This spoke requires an Integration Hub subscription. For more information, see Legal schedules - IntegrationHub overview.

Spoke version

Google Cloud SQL spoke v1.0.1 is the latest version. For version history of the spoke, see Google Cloud SQL spoke release notes.

Supported versions

This spoke was built for Google Cloud SQL v1beta4, but may be compatible with later versions.

Spoke requirements

• Google Cloud Platform account

• Google Identity and Access spoke (sn_gcpcloudsql_spk)

Spoke dependencies

If you’re having trouble installing the app, ensure that these dependent plugins are installed:

• • ServiceNow IntegrationHub Action Template - Data Stream (com.glide.hub.action_type.datastream)

• • ServiceNow IntegrationHub Action Step - REST (com.glide.hub.action_step.rest)

• • ServiceNow IntegrationHub Runtime (com.glide.hub.integration.runtime)

• • ServiceNow Flow Designer - Dynamic Inputs (com.glide.hub.dynamic_inputs)

• • Complex Object (com.glide.cobject)

Note: Some of these plugins are licensable features and require appropriate licenses, if used outside the spoke implementation.

Spoke actions

The Google Cloud SQL provides actions to automate tasks when events occurs in your ServiceNow instance. Available actions include:

Category Action Description Required Permission Back up Run Management: Create Backup Creates a backup. cloudsql.backupRuns.create Delete Backup Run Deletes a backup. cloudsql.backupRuns.delete Get Backup Run Retrieves details of the backup. cloudsql.backupRuns.get Look up Backup Runs Retrieves a list of the backup runs. cloudsql.backupRuns.list Database Management Create Database Creates a database. cloudsql.databases.create Delete Database Deletes a database. cloudsql.databases.delete Get Database Retrieves details of the instance. cloudsql.databases.get Look up Databases Retrieves a list of the databases. cloudsql.databases.list Update Database Updates a database. cloudsql.databases.update Instance Management Clone Instance Clones an instance. cloudsql.instances.clone Create Instance Creates an instance. cloudsql.instances.create Delete Instance Deletes an instance. cloudsql.instances.delete Get Instance Retrieves details of the instance. cloudsql.instances.get Look up Instances Retrieves a list of the instances. cloudsql.instances.clone Restart Instance Restarts an instance. cloudsql.instances.restart Update Instance Updates an instance. cloudsql.instances.update Operations Get Operation Retrieves details of the operation. N/A Look up Operations Retrieves a list of the operations. N/A Tiers Look up Tiers Retrieves a list of the tiers. N/A User Management Create User Creates a user. cloudsql.users.create Delete User Deletes a user. cloudsql.users.delete Look up User Retrieves a list of the users. cloudsql.users.list Update User Updates a user. cloudsql.users.update

Connection and credential alias requirements

Integration Hub uses aliases to manage connection and credential information, and OAuth credentials. Using an alias eliminates the need to configure multiple credentials and connection information profiles when using multiple environments. If the connection or credential information changes, you don’t need to update any actions that use the connection.

For information about setting up the spoke, see Set up the Google Cloud SQL spoke.