Skip to main content

Data Sources and Structure

Create a data source before scanning definitions, creating datasets, or exposing an API service.

Create A Data Source​

  1. Open Data Connect → Data sources and create a data source.
  2. Enter its name and select PostgreSQL, MySQL, MariaDB, SQL Server, or Oracle.
  3. Enter the host, port, database, username, and password. For Oracle, enter the service name rather than a connection descriptor.
  4. Choose TLS and, when needed, supply a CA certificate.
  5. Use Test connection to check the configuration.
  6. Save. Saving tests the submitted configuration again; a failed test prevents it from being saved.

Use a database account with the privileges required for the intended operation. Queries require read access. API inserts, updates, and deletes also require the corresponding database privileges; configuring an API role cannot grant database privileges.

When editing an existing source, leave the password empty to keep the saved password. Passwords are stored encrypted and are not returned in source details.

TLS​

TLS protects the connection between the tenant Runtime and the source database. It is separate from the HTTPS connection used by browsers or API clients.

SettingBehavior
EnabledRequests encrypted communication and verifies the database server's certificate and identity
DisabledDoes not request TLS; traffic can be unencrypted
CA certificate omittedUses the driver's default trust configuration
Custom CA certificateUses the supplied PEM certificate for certificate verification

The database must support TLS. An expired, untrusted, or mismatched certificate can prevent connection; the client does not automatically fall back to plaintext after TLS failure.

For private CA or self-signed certificates, supply the appropriate trusted certificate. Use a host name that matches the server certificate. Oracle uses TCPS and server identity verification; its connection form does not accept an uploaded CA certificate.

Scan Database Structure​

  1. Open the source's structure view.
  2. Start a structure scan and wait for completion.
  3. Browse schemas and tables, then inspect columns, native types, primary keys, and relationships.
  4. Use the changes view to examine differences from the previous scan.

The snapshot records structure, not a copy of the business records. Scanning structure does not change the source tables.

Use the scan schedule when database structure changes regularly. Check the last result and next scheduled run after saving the schedule.

Refresh After A Source Change​

After a column, key, or table changes in the source database:

  1. Run a new structure scan.
  2. Open affected form models and datasets.
  3. Refresh their structure and resolve missing or invalid fields and joins.
  4. Save the confirmed configuration and preview it.

A saved dataset retains its selected structure until you reconcile and save it. A structure change that makes that saved configuration unusable can block queries until it is repaired.

Troubleshooting​

ResultCheck
Cannot connectRuntime-to-database connectivity, host, port, and database listener
Authentication failedUsername, password, and database login policy
Database not foundDatabase name or Oracle service name
TLS failedServer TLS support, certificate chain, expiry, and host-name match
Connection succeeds but tables or queries failThe database account's schema, table, and operation privileges

Continue with form definition scanning, or create a dataset directly from database tables.