Oracle

Infoveave supports Datasource creation from databases like Apache Cassandra, MariaDB, Microsoft SQL, MongoDB, MySQL, Oracle, Percona and Postgres.

Creating Datasource using Oracle

Note

The configuration settings may change based on the file type you choose.

1. To access Infoveave Datasource types, navigate to Studio Datasource.All types of Datasources, created by you or shared with you will be displayed under My Datasources and Shared Datasources.
2. To create a new Datasource, click on New Datasource.
3. Choose Oracle under Databases as the Datasource type.
4. Select the connection from the dropdown. You can also add a connection by clicking on Add connection + icon.
5. Click on Save.
6. Enter the Datasource name.
7. Drag and drop the tables to the designer to configure measures and dimensions.
8. Enable measures and dimensions as per your requirements.

To learn about adding measures and dimensions to the data table, visit Measures and Dimensions.

To learn about adding calculated columns, visit Calculated Columns.

To learn about adding calculated measures, visit Calculated Measures.

Note

The connection between Oracle database and Infoveave must be preconfigured under Database Connections, in Control Center.