You can translate the document:

AlloyDB is a fully-managed, PostgreSQL-compatible database for demanding transactional workloads. It provides enterprise-grade performance and availability while maintaining 100% compatibility with open-source PostgreSQL.

NOTE: The support for AlloyDB for PostgreSQL was added in the Denodo 8.0 March 2023 update. AlloyDB for PostgreSQL is also supported as cache database.

To connect to AlloyDB for PostgreSQL, create a JDBC data source within the Denodo Platform:

  1. Open the Design Studio or the Virtual DataPort Administration Tool, log in and click the menu File > New > Data source > JDBC.
  2. Under Database adapter, select AlloyDB for PostgreSQL.

  1. Enter the connection details to the AlloyDB for PostgreSQL instance.
  2. Click Save. To validate that the connection is successful, click Test Connection.

Then you can create the base views that will represent the AlloyDB for PostgreSQL tables:

  1. Click CREATE BASE VIEW
  2. Click + to expand the schemas you are interested in.
  3. Select the tables you want to import.
  4. Click Create Selected.

  1. The base view is now created.

To query one of the base views you just created, follow these steps:

  1. Open the view and click on Execution panel.

  1. In the tab below, you can enter a WHERE condition for the query. Click Execute to query the new view.

References

AlloyDB for PostgreSQL | Google Cloud

Virtual DataPort Administration Guide: JDBC Sources

Virtual DataPort Administration Guide: Creating Base Views from a JDBC Data Source

Questions

Ask a question

You must sign in to ask a question. If you do not have an account, you can register here