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 a message will appear indicating success and the version of the underlying database.

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

AlloyDB for PostgreSQL release notes | Google Cloud

Virtual DataPort Administration Guide: JDBC Sources

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

Disclaimer
The information provided in the Denodo Knowledge Base is intended to assist our users in advanced uses of Denodo. Please note that the results from the application of processes and configurations detailed in these documents may vary depending on your specific environment. Use them at your own discretion.
For an official guide of supported features, please refer to the User Manuals. For questions on critical systems or complex environments we recommend you to contact your Denodo Customer Success Manager.

Questions

Ask a question

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