SSIS Components for DigitalOcean

Build 20.0.7587

DatabaseReplicas

Retrieve information regarding the database replicas. Read-only replicas are not supported for Redis clusters.

View Specific Information

Select

Digital Ocean supports only DatabaseId and Name columns with "=" operator as filter criteria for this view.

Note: The DatabaseId columns is a required filter. The driver will fetch a list of all database clusters if this filter is not present as part of the criteria.

SELECT * FROM DatabaseReplicas WHERE DatabaseId='9cc10173-e9ea-4176-9dbc-a4cee4c4ff30' AND Name = 'DatabaseName'

You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any other search criteria will be ignored and an unfiltered response will be returned.

Columns

Name Type References Description
Name [KEY] String A unique, human-readable name referring to a database cluster.
DatabaseId String

DatabaseClusters.Id

A unique ID that can be used to identify and reference a database cluster.
ConnectionDatabase String The name of the default database.
ConnectionHost String The FQDN pointing to the database cluster's current primary node.
ConnectionPassword String The randomly generated password for the default user.
ConnectionPort Integer The port on which the database cluster is listening.
ConnectionSsl Boolean A boolean value indicating if the connection should be made over SSL.
ConnectionUri String A connection string in the format accepted by the psql command. This is provided as a convenience and should be able to be constructed by the other attributes.
ConnectionUser String The default user for the database.
PrivateConnectionDatabase String The name of the default database.
PrivateConnectionHost String The FQDN pointing to the database cluster's current primary node.
PrivateConnectionPassword String The randomly generated password for the default user.
PrivateConnectionPort Integer The port on which the database cluster is listening.
PrivateConnectionSsl Boolean A boolean value indicating if the connection should be made over SSL.
PrivateConnectionUri String A connection string in the format accepted by the psql command. This is provided as a convenience and should be able to be constructed by the other attributes.
PrivateConnectionUser String The default user for the database.
CreatedAt Datetime Represents when the database cluster was created.
Region String The slug identifier for the region where the database cluster is located.
Status String A string representing the current status of the database cluster. Possible values include creating, online, resizing, and migrating.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7587