|
Field
|
Value for ORACLE Database Type
|
Value for SNOWFLAKE Database Type
|
|---|---|---|
|
Connection Name
|
PAIAdvancedDefault
|
PAIAdvancedDefault
|
|
Provider
|
ORACLE
|
SNOWFLAKE
|
|
Driver Version
|
12.2.0.1
|
3.9.2
|
|
Server
|
The IP address or the name of the machine where the database is installed
|
The user host URL name
|
|
Port
|
The port number where the database server listens. The default port for Oracle is 1521
|
N/A
|
|
DB
|
N/A
|
The name of the SNOWFLAKE database
|
|
WAREHOUSE
|
N/A
|
The warehouse associated with the SNOWFLAKE account that will be used for Intellicus query execution
|
|
Username
|
The PAI schema username
|
The SNOWFLAKE account name
|
|
Password
|
The password associated with the username
|
The password associated with the SNOWFLAKE account name
|
|
Connection String
|
N/A
|
Do the following to set the value for this field:
a. Clear the checkbox for Mask Connection String
b. In the Connection String box, add the following to the end of the string:
&schema=<schema>
c. Select the checkbox for Mask Connection String
|
|
Charset Encoding
|
UTF-8
|
UTF-8
|
|
Read only
|
Select the checkbox
|
Select the checkbox
|
|
Is default
|
Clear the checkbox
|
N/A
|
|
SID
|
The SID name
|
N/A
|
|
Is Repository
|
The checkbox should be empty
|
N/A
|
|
Field
|
Value
|
|---|---|
|
Pool Settings
|
Intial Connection(s) = 5
Resubmit Time = 30
Incremental Size = 5
Max. Connections = 30
|
|
Encrypted
|
Is selected
|
|
Cache
|
Select Boot Up
|