Aqtra Platform is a complex cross-platform application development and execution environment, allowing create very sophisticated applications. As with every development environment in complex cloud architecture, there is sometimes a need to access directly the data stored in Aqtra Platform database. This can be done using pgadmin4 tool.

Using pgAdmin4 to access Aqtra Platform Database

In some cases, it is important to have access to data stored in Aqtra Platform database for a specific Studio instance. It is done using pgAdmin4 tool usually provided together with Aqtra Platform. If your instance of Aqtra Platform has pgAdmin tools setup, you can access them via <your-main-host>/pg-admin/browser url. Note that you will need specific credentials to access pgAdmin and the database, that should be provided to you by your admin.

Once you’ve accessed pgAdmin tools, you should see something like the following.

If you have your pgAdmin tools connected to more than one database instance, then you will need to navigate to the proper instance. The name of the proper instance should be <your-host-name-no-domain>_DwContext2, as shown on the screenshot above.

Select DB schemas accessible to application developers

The list of schemas of potential interest to an application developer is shown on the screenshot below:

Here are quick descriptions of the important schemas from the list above

• Catalogs - this is the main data storage schema for all components. Data stored in the schema were either added manually via forms in Workplace, or via upload from external sources
• Dataflow - schema contains all DataFlows available for a specific Studio instance, including multiple versions of the same DataFlow. It also includes data for all integrations in JSON format
• file_storage - schema allows access to all files loaded into the specific Aqtra Platform instance. Importantly, it includes GUID to each file, allowing it to be used in scripts and during fields mapping
• Identity - schema contains user data including roles and permission sets