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

Request apps on the Store

Visit the ServiceNow Store website 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.

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.