Patria Tech Docs

Patria Tech Docs

Runbook: Sensedia Integrations — Verify a Data Source

Runbook: Sensedia Integrations — Verify a Data Source

FieldValue
SystemSensedia Integrations
ProcedureVerify and test the configuration of a Data Source (JDBC connector)
OwnerIT Production
Estimated time10 minutes
Maintenance window required?No
Approval required?No (read-only / connectivity test)

Pre-conditions

Before running this runbook, verify:

  • Active username and password on the Sensedia platform.
  • Access to the Patria tenant with read permissions in Production.
  • The name of the datasource to verify is known (e.g., ConexionGeneva, Conexion-ETL).
  • The datasource password is available to run the connectivity test.

Note: The datasource password is not stored in plain text on the platform. To test the connection, it must be entered manually. Request the credential from the DBA or Infrastructure team if not available.

Rollback plan

This runbook is read-only / verification only. If datasource configuration is modified, the rollback consists of restoring the previous values (URL, user, password) in the same edit modal.

Procedure

Step 1 — Log in to the platform

Open a browser and navigate to: https://signin.platform-production.sensedia.com/tenant-signin

In the Tenant Alias field, enter Patria and click Go to your account. Enter your username and password, then confirm the login.

Expected result: The My Products screen loads successfully.

Step 2 — Navigate to Data Sources

On the My Products screen, click the red Integrations tile. In the left-hand menu, select Data Sources.

Expected result: The Data Sources screen is displayed with the list of available connectors.

Step 3 — Search for the datasource

In the search box, enter the name of the datasource to verify. Optionally, filter by Database Type or Environment. Click SEARCH.

Expected result: The datasource appears in the results list with its environment badges (e.g., Production CONFIGURED, Staging CONFIGURED).

Step 4 — Open the datasource configuration

In the Actions column of the result, click the pencil (edit) icon.

Expected result: The list of configured environments for the datasource is displayed (Production, Staging, etc.), each with a CONFIGURED status badge.

Step 5 — Access the Production configuration

Click the pencil icon to the right of the Production environment.

Expected result: The environment configuration modal opens, showing:

  • URL: JDBC connection string (e.g., jdbc:sqlserver://HOST:PORT;databaseName=DB_NAME)
  • User: database connection username
  • Password: masked field (not visible)

Step 6 — Verify the connection parameters

Check that the URL and User values are correct according to the datasource documentation or the information provided by the DBA team.

Expected result: The connection parameters match the expected values for the Production environment.

Step 7 — Test connectivity (optional)

To verify that the connection is active:

  1. Enter the datasource Password in the corresponding field.
  2. Click the TEST button.

Expected result: The platform confirms that the connection is successful.

If the test fails, check:

  • That the entered password is correct and current.
  • That the database server is available and reachable from the Sensedia platform.
  • That the JDBC URL contains the correct host, port, and database name.

Click CANCEL to close the modal without saving changes (unless a value was corrected).

Step 8 — Final verification

  • The datasource parameters (URL, User) are correct.
  • The connectivity test was successful (if performed).
  • No unintended changes were made to the configuration.

Troubleshooting

Error / SymptomLikely causeSolution
Datasource not found in the search resultsIncorrect name or datasource not yet createdVerify the exact name with the integration team; see the “Create a new datasource” section below
Environment badge does not show CONFIGUREDThe environment configuration is incompleteEdit the environment and complete the URL, User, and Password fields
Connection test fails (credentials)Expired or incorrect passwordRequest a credential reset from the DBA team
Connection test fails (timeout/network)Database server unreachable from SensediaVerify server availability; review firewall/network rules with the Infrastructure team
Changes saved accidentallyClicked CONFIRM instead of CANCELRestore the original values (URL, User, Password) by editing the environment again

Create a new datasource

If the datasource does not exist, it can be created from the Data Sources screen:

  1. Click the + DATA SOURCE button (top right corner).
  2. Fill in the required fields: name, database type, JDBC URL, username, and password per environment.
  3. Run the connectivity test before confirming.
  4. Click CONFIRM to save.

Creating a new datasource must be coordinated with the Integrations and DBA teams to ensure that credentials and network connectivity are properly configured.

References