Apigee Connector Integration (Cloud SQL for PostgreSQL)

[shrenikkumar-s]

We're asked about connecting to Cloud SQL and fetch/update table in DB capabilities in Apigee X [Apigee X --> Cloud SQL].

Basically requirement is Apigee to connect to Cloud SQL and fetch/update table.

I see it is possible looking at:
1. Create a DB connector: https://cloud.google.com/integration-connectors/docs/connectors/cloudsqlforpostgresql/configure
2. Create and publish an integration with an API Trigger (uses the connector from step 1): https://cloud.google.com/apigee/docs/api-platform/integration/getting-started-apigee-integration
3. Create an Apigee Integration target proxy (uses the integration from step 2): https://cloud.google.com/apigee/docs/api-platform/integration/getting-started-apigee-target-endpoint

Is my understanding correct?
1. Could you please help to add if I'm missing anything
2. Any working example on Git/Youtube would immensely help

Thanks

@kurtkanaskie @dchiesa1 @Sai Saran Vaidyanathan
@dknezic @ganadurai @Harish123 @Manisha_Chennu