Connect to Your Data
You can connect to your data in several ways. First, you must initiate a connection to your database data source. You can also add a spreadsheet as a data source or connect to data using datasets.
On this page:
Connect to Your Database Source
Analytics Visualization comes with a connection to your software-as-a-service (SaaS) database data source. However, the connection must be initiated.
- Sign in to Oracle Utilities Analytics Visualization.
- Click the Create button from the menu bar, and then click Connection.
- In the dialog that displays, click OK.
Add a Spreadsheet as a Data Source
You can add a spreadsheet as a data source in Analytics Visualization. See the external topic Create Datasets from Files for details on performing this task.
Connect to Data Using Datasets
You can connect to your data using datasets and perform a variety of data visualization and analysis tasks. Datasets are self-service data models that you build specifically for your data visualization and analysis requirements. See the external topic Connect to Your Data Using Datasets for more information, and review the following applicable topics:
- About Opening Datasets
- What Are Datasets?
- Create a Dataset from a Connection
- Create Datasets from Files
- View Available Connections
- Data Sources Available for Use in Datasets
- About the Dataset Editor
- Create a Dataset From a Connection
- Add Multiple Connections to a Dataset
- Add a Table to a Dataset Using a SQL Statement
Note: Analytics Visualization only supports creating or opening datasets from spreadsheets and the source database. See the restrictions below for more information.
Restrictions
As described in the external topic About Data Sources, there are various options for connecting to data sources. However, some of these options are restricted in Oracle Utilities Analytics Visualization. The restrictions include:
- You can create a connection to the Customer Cloud Service (CCS) database, Work and Asset Cloud Service (WACS) database, or Meter Solution Cloud Service (MSCS) database and use it as your data source. Only one connection can be created for each cloud service that you have purchased. For example, if you have purchased CCS, you can create a connection to the CCS source database.
- You can add data from a spreadsheet or csv file data source.
- You cannot edit or delete the connection details to your CCS, WACS or MSCS database data source
- You cannot create a connection to a database that is not the CCS, MSCS or WACS database
- You cannot connect to Oracle Applications Data Sources. This means the following tasks are not supported:
- Connect to Data Sources
- Connect to an Oracle Database