Oracle connector
Oracle Database (commonly referred to as Oracle RDBMS or simply as Oracle) is a multi-model database management system produced and marketed by Oracle Corporation. The following table lists the versions that have been tested in the lab setup:
|
Platforms |
Version |
|---|---|
|
Linux |
|
-
User on source database must select privileges
-
User on target database side must have all privileges and SELECT_CATALOG_ROLE.
Supported data types
The following are the different data types that are tested in our lab setup:
-
VARCHAR
-
VARCHAR2
-
NUMBER
-
FLOAT
-
DATE
-
TIMESTAMP(default)
-
CLOB
-
BLOB(with text)
Hyperscale Compliance restricts the support of the following special characters for a database column name: ~!@#$%^&*()\\\"?:;,/\\\\`+=[]{}|<>'-.\")]
Property values
|
Property |
Value |
|---|---|
|
|
|
|
|
|
For default values, see Configuration settings .
MS SQL connector
Supported versions
Microsoft SQL Server 2019
Supported data types
The following are the different data types that are tested in our lab setup:
-
VARCHAR
-
CHAR
-
DATETIME
-
INT
-
TEXT
-
XML (only unload/load))
-
VARBINARY (only unload/load)
-
SMALLINT
-
SMALLMONEY
-
MONEY
-
BIGINT
-
NVARCHAR
-
TINYINT
-
NUMERIC(X,Y)
-
DECIMAL(X,Y)
-
FLOAT
-
NCHAR
-
BIT
-
NTEXT
-
MONEY
Property values
|
Property |
Value |
|---|---|
|
|
|
|
|
|
For default values, see Configuration settings .
Known limitations
-
If the applied algorithm's produced mask data exceeds the corresponding target table columns datatype's max value range, then job execution will fail in load service.
-
Schemas, tables, and column names having special characters are not supported.
-
Masking of columns with
VARBINARYdatatype is not supported. -
Hyperscale Compliance can mask up to a maximum 1000 tables in a single job.