Using Other Tools or the REST API to Add Data

You can use Data Sync or the REST API to add data. With Data Sync, you can schedule data uploads to automatically create and refresh data sets.

Data Sync

Download Data Sync from OTN and install it locally on your Windows or UNIX machine. With Data Sync, you can upload on-premises data from various sources to a data set you can explore in Oracle Data Visualization Cloud Service:

  • Data files (CSV and Microsoft Excel XLSX).

  • Relational sources (Oracle, Microsoft SQL Server, DB2, Teradata, MySQL, Oracle TimesTen)

  • SQL Query

  • OTBI sources (Oracle Transactional Business Intelligence)

You need the User application role in Oracle Data Visualization Cloud Service to add data using Data Sync. See Assigning Application Roles to Users.

REST API

Use the Oracle Data Visualization Cloud Service REST API to programmatically load on-premises data to a data set that you can explore in your Oracle Data Visualization Cloud Service. To find out more, see REST API for Oracle Data Visualization Cloud Service.