Connect to Your Data

Oracle Utilities Analytics Visualization comes with a connection to your software-as-a-service (SaaS) database data source. However, the connection must be initiated.

To connect to your SaaS database data source:

  1. Sign in to the Oracle Utilities Analytics Visualization application.
  2. Click the Create button from the menu bar, and then click Connection.
  3. In the dialog that displays, click OK.

To add a spreadsheet as a data source:

See Create a Dataset from a File Uploaded From Your Computer.

Restrictions

As described in 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 Oracle Applications
  • Connect to an Oracle Database

Back to Top