PostgreSQL (OFBiz) - ofbiz

PostgreSQL (OFBiz) - ofbiz database

Create Source endpoint

  1. First, you need to get the EC2 private IP address where OFBiz database is running. Go to Services, EC2, Instances. Add “ofbiz-db.onpremsim.env” as a filter. Then, select the EC2 instance and write down the IP in Private IPs field: Get OFBiz DB private IP

    The IP address above is only an example. Your IP address may be different.

  2. And then, return to Database Migration Services (DMS) service. Go to Services, Database Migration Services.

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

  4. Endpoint type: Source endpoint.

  5. Endpoint configuration:

    • Endpoint identifier: SourceOFBiz
    • Source engine: postgres
    • Server name: Use the IP address that you wrote down in step 1
    • Port: 5432
    • User name: ofbiz
    • Password: Same password used to logon to the linux box
    • Database name: ofbiz 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

  6. 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.
  7. After the successful 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 after select the RDS Instance: mid-ofbiz-instance-1.

  4. In Endpoint configuration:

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

    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 successful status, click on Create endpoint Select target endpoint OFBiz