Oracle
Infoveave supports Datasource creation from databases such as Apache Cassandra, MariaDB, Microsoft SQL, MongoDB, MySQL, Oracle, Percona, and Postgres.
Creating a Datasource Using Oracle
- To access Infoveave Datasource types, navigate to Studio Datasources. All types of Datasources created by you or shared with you are displayed under My Datasources and Shared Datasources.
- To create a new Datasource, click on New Datasource.
- Choose Oracle under Databases as the Datasource type.
- Select the connection from the dropdown. You can also add a connection by clicking on the Add connection + icon.
- Click on Save.
- Enter the Datasource name.
- Drag and drop the tables into the designer to configure measures and dimensions.
- Enable the 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.