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": "${SOURCE_USERNAME}",
    "password": "${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.