Autonomous Data Warehouse Cloud (ADWC) is a fully-managed, high-performance elastic cloud service providing analytical capability over data stored in the database and Oracle Object Store.
Type Name
oracle
Connection Properties
Template name: oracleadwc
Appropriate translator name: oracleadwc
Properties:
- tns (the service name of the Oracle ADWC instance, which can be found in the
tnsnames.ora
file within the wallet) user-name
password
(default: empty )wallet
( a path to a ZIP file or a Base64 string presentation of the ZIP-file; see note below)tns_admin
( a path to the unzipped wallet directory; default:dvserver/standalone/deployments/wallets/wallet_<tns>/
; the path should end with '/')jdbc-properties
(arbitrary extra properties)new-connection-sql
(default:alter session set nls_sort = BINARY
)min-pool-size
(default:2
)max-pool-size
(default:70
)
Note: The wallet
property is stored in the SYSADMIN.Connections
table as a Base64 string even when set as a path to a ZIP file. In the import script, it will also be presented as a Base64 string, therefore the ZIP file does not need backing up for migration.
tns_admin
is available since v4.0.7keyStorePWD
and trustStorePWD
removed in v4.0.7Examples
1. Example with wallet
as a path to a ZIP file:
CALL
"SYSADMIN.createConnection"
(
"name"
=>
'adwc'
,
"jbossCLITemplateName"
=>
'oracleadwc'
,
"connectionOrResourceAdapterProperties"
=>
'tns=<tns>, user-name=<user-name>, password=<password>, wallet=d:/adwc_wallet.zip'
,
"encryptedProperties"
=>
''
) ;;
CALL
"SYSADMIN.createDataSource"
(
"name"
=>
'adwc'
,
"translator"
=>
'oracleadwc'
,
"modelProperties"
=>
'importer.useFullSchemaName=false, importer.TableTypes="TABLE,VIEW", importer.importIndexes=false, importer.schemaPattern="ADMIN",importer.defaultSchema="ADMIN"'
,
"translatorProperties"
=>
'trustStorePWD=<trustStorePWD>, keyStorePWD=<keyStorePWD>'
,
"encryptedModelProperties"
=>
''
,
"encryptedTranslatorProperties"
=>
''
);;
2. Example with wallet
as a Base64 string:
CALL
"SYSADMIN.createConnection"
(
"name"
=>
'adwc'
,
"jbossCLITemplateName"
=>
'oracleadwc'
,
"connectionOrResourceAdapterProperties"
=>
'tns=<tns>, user-name=<user-name>, password=<password>, wallet=<Base64 string>'
,
"encryptedProperties"
=>
''
) ;;
CALL
"SYSADMIN.createDataSource"
(
"name"
=>
'adwc'
,
"translator"
=>
'oracleadwc'
,
"modelProperties"
=>
'importer.useFullSchemaName=false, importer.TableTypes="TABLE,VIEW", importer.importIndexes=false, importer.schemaPattern="ADMIN",importer.defaultSchema="ADMIN"'
,
"translatorProperties"
=>
'trustStorePWD=<trustStorePWD>, keyStorePWD=<keyStorePWD>'
,
"encryptedModelProperties"
=>
''
,
"encryptedTranslatorProperties"
=>
''
);;
Translator Properties
Translator Properties Shared by All JDBC Connectors
(Properties listed in alphabetical order)
To view the full table, click the expand button in its top right corner
Name | Description | Default value |
---|---|---|
| Sets a template to convert Examples comparisonStringConversion=%s -- no conversion will be applied comparisonStringConversion= binary %s -- WHERE binary someStringExpression LIKE someOtherStringExpression comparisonStringConversion=(%s COLLATE Latin1_General_CS_AS) -- WHERE (someStringExpression COLLATE Latin1_General_CS_AS LIKE someOtherStringExpression) |
|
| Database time zone, used when fetching date, time, or timestamp values | System default time zone |
| Specific database version, used to fine-tune pushdown support | Automatically detected by the server through the data source JDBC driver, if possible |
| Only considered when |
|
| If |
|
| Maximum size of prepared insert batch |
|
| Sets a template to convert Examples OrderByStringConversion=%s -- no conversion will be applied OrderByStringConversion=( binary %s) -- ORDER BY (binary someStringExpression) OrderByStringConversion= cast ((%s) as varchar (2000) ccsid 1208) -- ORDER BY cast((someStringExpression) as varchar(2000) ccsid 1208) |
|
| If |
|
| Forces a translator to issue a Example SELECT x.* FROM table ( CALL "dwh.native" ( "request" => 'SELECT query, pid, elapsed, substring FROM svl_qlog ORDER BY STARTTIME DESC LIMIT 200' ) ) w , ARRAYTABLE( w.tuple COLUMNS query string, pid integer , elapsed string, "substring" string ) x; |
|
| If If |
|
| If If |
|
| If |
|
| if |
|
| Embeds a / comment / leading comment with session/request id in the source SQL query for informational purposes |
|
The names of the translator properties are case-sensitive.
Translator Properties Specific for Oracle ADWC
Name | Description | Default value |
---|---|---|
| When set to TRUE, the Data Virtuality Server treats Oracle date data type as timestamp data type |
|
| Maximum length of a table name |
|
| Maximum length of a column name. Please note that five chars of defined maximum length will be reserved for internal purposes and cannot be used for column identifier |
|
| Indicates that the Oracle-supplied driver (typically prefixed by |
|
Data Source Properties
Data Source Properties Shared by All JDBC Connectors
(Properties listed in alphabetical order)
To view the full table, click the expand button in its top right corner
Name | Description | Default |
---|---|---|
| Replaces |
|
| Database catalogs to use. Can be used if the Only for Microsoft SQL Server and Snowflake:
| Exasol: EXA_DB All others: empty |
|
Please note that writing into a data source is only possible if this parameter is set. | Empty |
| Turns on metadata cache for a single data source even when the global option is turned off. Together with |
|
| Case-insensitive regular expression that will exclude a matching fully qualified procedure name from import | Empty |
| Comma-separated list of schemas (no | Oracle: APEX_PUBLIC_USER, DIP, FLOWS_040100, FLOWS_020100, FLOWS_FILES, MDDATA, ORACLE_OCM, SPATIAL_CSW_ADMIN_USR, SPATIAL_WFS_ADMIN_USR, XS$ NULL , BI, HR, OE, PM, IX, SH, SYS, SYSTEM, MDSYS, CTXSYS All others: empty |
| Case-insensitive regular expression that will exclude a matching fully qualified table name from import. Does not speed up metadata loading. Here are some examples: 1. Excluding all tables in the (source) schemas importer.excludeTables=(.*[.]sys[.].*|.*[.]INFORMATION_SCHEMA[.].*) 2. Excluding all tables except the ones starting with "public.br" and "public.mk" using a negative lookahead: importer.excludeTables=(?! public \.(br|mk)).* 3. Excluding "tablename11" from the list ["tablename1", "tablename11", "company", "companies"]: importer.excludeTables=.*\.(?!\btablename1\b|\bcompan).*
| Empty |
| Fetch size assigned to a resultset on loading metadata | No default value |
| If set to |
|
| If set to |
|
| If set to |
|
| If set to Please note that it is currently not possible to import procedures which use the same name for more than one parameter (e.g. same name for |
|
| Set to |
|
| If set to |
|
| If set to |
|
| Procedure(s) to import. If omitted, all procedures will be imported. | Empty |
| If set to |
|
| If set to |
|
| If set to |
|
| If set to |
|
| Schema(s) to import. If omitted or has "" value, all schemas will be imported. | Empty |
| If set to |
|
| Table(s) to import. If omitted, all tables will be imported. | Empty |
| Comma-separated list (without spaces) of table types to import. Available types depend on the DBMS. Usual format: Other typical types are | Empty |
| If set to | |
| If set to Please note that this may lead to objects with duplicate names when importing from multiple schemas, which results in an exception |
|
| If set to |
|
| If set to |
|
Escaping wildcards in importer.catalog
available since v4.0.8
Default values
and importer.catalog='EXA_DB'
importer.useCatalogName=FALSE
available since v4.4
importer.loadSourceSystemFunctions
is available since v4.6
set to importer.importProcedures
TRUE
by default for CData connector since v4.7
Data Source Properties Specific for Oracle ADWC
Name | Description | Default value |
---|---|---|
| Set to |
|
| Set to |
|