PostgreSQL (OFBiz) - ofbiztenant

PostgreSQL (OFBiz) - ofbiztenant database

Create Source endpoint

  1. Open the Database Migration Services (DMS) service. Go to Services, Database Migration Services.

  2. In the navigation pane, click Endpoints, then select Create endpoint. Create source endpoint OFBiz

  3. Endpoint type: Source endpoint.

  4. In Endpoint configuration:

    • Endpoint identifier: SourceOFBiz-ofbiztenant
    • Source engine: postgres
    • Server name: Use the IP address that you wrote down in step 1 in the section “PostgreSQL (OFBiz) - ofbiz”
    • Port: 5432
    • User name: ofbiz
    • Password: Same password used to logon to the linux box
    • Database name: ofbiztenant Select source endpoint OFBiz

      The IP address above in the field Server name is only an example. Your IP address may be different. Use the IP address that you wrote down in step 1

  5. Expand Test endpoint connection. Select:

    • VPC: Target
    • Replication Instance: mid-repinst-ofbiz
    • Click on Run test. Wait for the test result. In case of error, review the parameters again.

  6. After the sucessful status, click on Create endpoint Select source endpoint OFBiz

Create Target endpoint

  1. In the navigation pane, click Endpoints, then select Create endpoint. Create target endpoint OFBiz

  2. Select Endpoint type: Target endpoint.

  3. Check box Select RDS DB instance and select the RDS Instance: mid-ofbiz-instance-1.

  4. In Endpoint configuration:

    • Endpoint identifier: TargetOFBiz-ofbiztenant
    • Password: the same password that you set when you created the RDS database
    • Database name: ofbiztenant

    All other settings can be used as the default values. Select target endpoint OFBiz

  5. Expand Test endpoint connection. Select:

    • VPC: Target
    • Replication Instance: mid-repinst-ofbiz
    • Click on Run test. Wait for the test result. In case of error, review the parameters again.

  6. After the sucessful status, click on Create endpoint Select target endpoint OFBiz

Checkpoint before moving to the next section

In the navigation pane, click Endpoints. Check if you have the following Types and Engines. You should have 4 Sources and 4 Targets, in a total of 8 endpoints:

Type Engine
Source PostgreSQL
Source PostgreSQL
Source PostgreSQL
Source MariaDB
Target Amazon Aurora PostgreSQL
Target Amazon Aurora PostgreSQL
Target Amazon Aurora PostgreSQL
Target Amazon Aurora MySQL

Double check Endpoints