Validate Database Connection

Once the REST HTTP service is up and running, to validate a successful database connection can be achieved, run:

  curl -X 'POST' \
    'http://${API_SERVICE_URL}:${API_SERVICE_PORT}/api/v1/validate-connection' \
  -H 'accept: application/json' \
  -H 'Content-Type: application/json' \
    -d '{
    "jdbc_url": "jdbc:${SOURCE_DRIVER_PREFIX}://${SOURCE_URL}:${SOURCE_PORT}",
    "user": {
      "type": "raw",
      "value": "${SOURCE_USERNAME}"
    },
    "password": {
      "type": "raw",
      "value": "${SOURCE_PASSWORD}"
    }
  }'

Where:

  • jdbc_url (required): JDBC url of the database, e.g. jdbc:postgresql://39.176.0.1:5432/.

  • user (optional): Username to access the database, if authentication is needed.

  • password (optional): Username’s password to access the database, if authentication is needed.