Connecting to Oracle
DataVeil supports connections to Oracle 10g and later. DataVeil uses JDBC for connection.
The form displayed in the Connection window for Oracle connections is shown below:
NOTE: DataVeil attempts to present a user interface in a database-agnostic manner. Consequently, there can be some ambiguity with terminology used. For example, DataVeil's use of the term "database" generally corresponds to what is generally referred to in Oracle as a "schema" (keep this in mind when reading DataVeil log messages.) In some specific cases, such as in the Oracle-specific connection form shown above, the Oracle term "schema" is used.
In the example shown above, the schema (owner) name is "KONA" and the username is "ref001". The schema name should be in uppercase.
It is important to realize that if 'Schema Name' is not recognized by Oracle or if the Username does not have access permissions, then Oracle will still accept the connection. In such a situation, DataVeil shall provide a list of all schema names accessible to Username. You can either select an available schema name from the list or cancel the connection attempt.
Please check with your DBA to ensure that your Username has the required access and permissions. In order to Run DataVeil masking projects, the Username must have broad DBA-level permissions. DataVeil needs to create and drop tables, indexes, triggers and constraints.
You can specify other execution parameters that apply to this connection such as masking batch sizes and the maximum number of parallel JDBC connections (threads). Please refer to Execution Settings for details.