Oracle

1. Create a Oracle Read-Only User

To connect to Oracle , create a user with read-only access to all tables you wish to compare. Include read and write access to a Datachecks-specific temp schema:

    /* Switch container context (default is "XEPDB1") */
    ALTER SESSION SET CONTAINER = YOURCONTAINER;

    /* Create a Datachecks user/schema */
    CREATE USER DATACHECKS IDENTIFIED BY yoursecurepassword;

    /* Allow Datachecks user to connect */
    GRANT CREATE SESSION TO DATACHECKS;

    /* Allow user to create tables in DATACHECKS schema */
    GRANT CREATE TABLE TO DATACHECKS;

    /* Grant read access to compare tables in your schema */
    GRANT SELECT ON "YOURSCHEMA"."YOURTABLE" TO DATACHECKS;

    /* Grant access to DBMS_CRYPTO utilities (hashing functions, etc.) */
    GRANT EXECUTE ON SYS.DBMS_CRYPTO TO DATACHECKS;

    /* Allow Datachecks users/schemas to use disk space (adjust if needed) */
    GRANT UNLIMITED TABLESPACE TO DATACHECKS;

    /* Apply the changes */
    COMMIT;

Datachecks uses a temporary dataset to handle intermediate processing while keeping your core data intact.

2. Add Oracle as a data source in Datachecks

Go to Settings > Datasources, click New Datasource, and select Oracle to configure the connection to your database.

Once selected, you’ll be directed to the configuration page. Enter the following details:

Field Name	Description
Host	The name of the server that hosts your database.
Port	The default port is 1521. If your server uses a different port, specify that.
Username	The name of the dedicated user for Datachecks.
Password	The password of the Datachecks user.
Service Name	The name of the database (Service) you want to connect to.
Connection Name	A name given to the data connection within Datachecks

Click Test & Save Datasource. Your data connection is ready!