Accessing Google Cloud SQL for PostgreSQL
The Job in this scenario demonstrates how to access Google Cloud SQL for PostgreSQL using the tPostgresqlOutput and the tPostgresqlInput components. For more information about Google Cloud SQL for PostgreSQL, see Using Cloud SQL for PostgreSQL.
In this scenario:
- tDBConnection_1 establishes a connection to a Google Cloud SQL for PostgreSQL instance.
- SubJob 1 writes data to a database table on the Google Cloud SQL for PostgreSQL instance.
- SubJob 2 retrieves data from the database table and displays the data in the console.
The following lists the data to write to the Google Cloud SQL for PostgreSQL
instance.
1;Griffith Paving and Sealcoatin;talend@apres91
2;Bill's Dive Shop;511 Maple Ave. Apt. 1B
3;Childress Child Day Care;662 Lyons Circle
4;Facelift Kitchen and Bath;220 Vine Ave.
5;Terrinni & Son Auto and Truck;770 Exmoor Rd.
6;Kermit the Pet Shop;1860 Parkside Ln.
7;Tub's Furniture Store;807 Old Trail Rd.
8;Toggle & Myerson Ltd;618 Sheriden rd.