Tip of the Day: Using the API to List Databases

  Thread closed by the administrator. It is viewable, but not accepting new replies.
  • 1.  Tip of the Day: Using the API to List Databases

    Posted 11-12-2014 06:14:00 PM
    No replies, thread closed.

    To obtain a list of dSources and VDBs, list available Container (also known as database) objects on the system:

    $ curl -X GET -k http://delphix-server/resources/json/delphix/database \
         -b ~/cookies.txt -H "Content-Type: application/json"

    For more information on the structure of a database object, see the /api/#Container reference on your local Delphix Engine. The following sub-types are available depending on the type of database:

    • OracleDatabaseContainer
    • MSSqlDatabaseContainer

    Each database has zero or one source associated with it. This source could be a linked source, indicating that the database is a dSource, or it could be a virtual source, indicating that it is a VDB. If there are no sources, it is a detached dSource. The parentContainer property indicates the reference to the parent container, also indicating that the database is a VDB. To get runtime information about the source associated with the dSource or VDB, use the Source API with a database parameter set to the reference of the database in question.