- User’s Guide for Oracle Analytics Desktop
- Connect to Data Sources
- Create a connection for an Oracle Database
Create a connection for an Oracle Database
You can create a connection to a database and use the connection to access data and build a data set.
- On the Home page, click Create, then click Connection.
- In the Create Connection dialog, click Oracle Database.
- Enter a name for the connection, and then enter the
required connection information, such as host, port, username, password, and
service name.
If you’re creating an SSL connection, in the Client Wallet field, click Select to browse for the
cwallet.sso
file. Ask your administrator for the location of thecwallet.sso
file. - Use the Connection Type option to specify how you'd like
to connect.
- When you create connections to Oracle Databases, you
can connect in two ways using the Connection Type option:
- Basic - Specify the Host, Port, and Service Name of the database.
- Advanced - In the
Connection String field specify the Single
Client Access Name (SCAN) ID of databases running in a RAC cluster. For
example:
sales.example.com =(DESCRIPTION= (ADDRESS_LIST= (LOAD_BALANCE=on)(FAILOVER=ON) (ADDRESS=(PROTOCOL=tcp)(HOST=123.45.67.111)(PORT=1521)) (ADDRESS=(PROTOCOL=tcp)(HOST=123.45.67.222)(PORT=1521)) (ADDRESS=(PROTOCOL=tcp)(HOST=123.45.67.333)(PORT=1521))) (CONNECT_DATA=(SERVICE_NAME= salesservice.example.com)))
-
Enable Bulk Replication - If you’re loading a data set for a project, then this option should be turned off and you can ignore it. This option is reserved for data analysts and advanced users for replicating data from one database to another database.
- When you create connections to Oracle Databases, you
can connect in two ways using the Connection Type option:
- Click Save.You can now begin creating data sets from the connection.
You can't use remote connections to save a data set from a Data Flow.