Manage Connections to Data Sources
You can create, update, remove, and share connections to data sources. As an Oracle Analytics user with DV Content Author access, you can perform these actions.
Topics:
Create a Connection to a Data Source
You can create a connection to enable you to analyze data in that data source.
Edit a Data Source Connection
You can update a data source's connection details.
If you’re editing an SSL connection to an Oracle Database and you need
to use a new cwallet.sso
file, in the Client
Wallet field, click Select to browse for the
cwallet.sso
file. Ask your administrator for the location
of the cwallet.sso
file.
Delete a Data Source Connection
You can remove a data source connection from Oracle Analytics Cloud. For example, you must delete a database connection and create a new connection when the database's password has changed.
If the connection contains any datasets, then you must delete the datasets before you can delete the connection.
- Go to the Data page and select Connections.
- Hover over the connection that you want to delete. To the right of the highlighted connection, click Actions, then select Delete.
- Click Yes.
Share a Data Source Connection
You can assign access permissions to the data source connections that you create or administer.
Database Connection Options
When you specify connection details using the Create Connection dialog or Inspect dialog, some database types have extra configuration options.
General Options
- 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 dataset for a workbook, 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.
Authentication Options
- Always use these credentials - Oracle Analytics always uses the login name and password you provide for the connection. Users aren’t prompted to log in.
- Require users to enter their own credentials - Oracle Analytics prompts users to enter their own user name and password for the data source. Users can only access the data for which they have the permissions, privileges, and role assignments.
- (Displayed if Oracle Analytics supports impersonation for this database type) Use the active user’s credentials - Oracle Analytics doesn't prompt users to sign in to access the data. The same credentials they used to sign in to Oracle Analytics are also used to access this data source.
System connection
Select System connection if you want to use these connection details in Semantic Modeler or Model Administration Tool.
- If you're modeling data using Semantic Modeler, choosing this option enables Semantic Modeler to connect to the data source. To find out which databases Semantic Modeler supports, look for a Yes in the 'Data Models - Semantic Modeler' column in the supported data sources list. See Certification - Supported Data Sources.
- If you're modeling data using Model Administration Tool, you can connect to some data sources by copying connection details from Oracle Analytics Cloud into Model Administration Tool. To find out which data sources support this, look for System Connection in the Connectivity Options in the Use in Model Administration Tool in Certification - Supported Data Sources. Click Copy, to copy the connection's Object ID. Business modelers can paste in the Object ID to identify and use a data connection in the Model Administration Tool (Connection Pool dialog).
Click Copy, to copy the connection's Object ID. Business modelers can paste in the Object ID to identify and use a data connection in the Model Administration Tool (Connection Pool dialog).
Note: If you don't click System connection when you initially create the connection, if you later want data modelers to use the connection details, then you have to create a new connection and select System connection. In other words, you can't edit the connection later and select this option.
Database Connection Limits
Understand your database connection requirements before your create the database connection.
The maximum number of database tables displayed in Oracle Analytics is 10,000. If you need additional tables, Oracle recommends that you ask your database administrator to create a database user with access to the specific objects you want to analyze and specify that user's credentials when you create the database connection.
Connect to Data With Upper, Lower, or Mixed-case Characters
If you're connecting to an Oracle database, Oracle Autonomous Data Warehouse, Oracle Transaction Processing, Snowflake, SQL Server, or My SQL, you can change the default quoting identifier so that you can read data with upper, lower, or mixed-case characters in table or column names.
select "EfG_Field" from "AbCd";
instead of issuing select EfG_Field from AbCd;
, (which would fail).