edit-icon download-icon

PostgreSql data source config

Last Updated: Apr 23, 2018

The PostgreSQL relational database data source provides the ability to read data from and write data to PostgreSQL, and supports configuring the synchronization task in both the wizard and script modes.

If you are using PostgreSQL in a VPC environment, note the following:

  • For the user‑created MySQL data source:

    • The connectivity test is not supported, but you can configure synchronization tasks. When creating a data source, you only need to click OK.

    • You must use the custom scheduling resource group to run the synchronization task. Make sure the connectivity is maintained between the custom scheduling resource group and your user‑created database. For more information, see Configure VPC environment to achieve data synchronization.

  • For the PostgreSQL data source created by using RDS: The system automatically selects the network environment, based on the RDS instance information provided by you.

Procedure

  1. Enter the DataWorks console as a developer, and click Enter Project, as shown in the following figure.

    EnterProject

  2. Click Data Integration from the upper menu and navigate to the Data Sources page.

    DataSources

  3. Click New Source.

  4. In the dialog box, select PostgreSQL as the data source type.

    • Alibaba Cloud database (RDS)

      12

      • Type: The selected network type.

      • Name: A combination of letters, numbers, and underscores (). It must begin with a letter or an underscore (), and the length must not exceed 60 characters.

      • Description: A brief description of the data source, which must not exceed 80 characters.

      • examples of rds ID: The RDS instance ID.

      • examples of rds buyers id: RDS buyers account ID.

      • database name: The name of database.

      • Username/Password: The username and password of the database.

    • Public IP

      PublicIP

      • Type: Public IP.

      • Name: A combination of letters, numbers, and underscores (). It must begin with a letter or an underscore (), and the length must not exceed 60 characters.

      • Description: A brief description of the data source, which must not exceed 80 characters.

      • JDBC URL: An identifier to connect to the specified remote database. The format is jdbc:mysql://ServerIP:Port/Database.

      • User Name/Password: The username and password of the database.

    • No public IP

      NopublicIP

      • Type: No public IP.

      • Name: A combination of letters, numbers, and underscores (). It must begin with a letter or an underscore (), and the length must not exceed 60 characters.

      • Description: A brief description of the data source, which must not exceed 80 characters.

      • Select resource group: It can be used to perform synchronization tasks, and in general, multiple machines can be bundled when a resource group is added. For more information, see Add scheduling resources.

      • JDBC URL: An identifier to connect to the specified remote database. The format is jdbc:mysql://ServerIP:Port/Database.

      • Username/Password: The username and password of the database.

  5. Click Test Connectivity.

  6. When the connectivity test is passed, click Complete.

Connectivity test description

  • In a classic network, the connectivity test is provided to verify whether the JDBC URL and Username/Password entered are correct.

  • Currently, test of the connectivity to data sources is unavailable in VPC environments.

What to do next

Now you have learned how to configure the PostgreSQL data source. The article explains how to configure the PostgreSQL Writer plug‑in later. For more information, see Configure PostgreSQL Writer.

Thank you! We've received your feedback.