Working with Datasources in the AIV application

Datasource tab is the first sub-tab under the Master Data tab in AIV application.

Datasource tab enable users to create new datasource and connect to different data sources from the AIV application.

Datasource section of AIV application supports connection to external databases via the mode of following interfaces:-

  1. JDBC
  2. Big Query
  3. OLAP
  4. NOSQL
  5. Custom

Datasource section of AIV application supports following external database management systems:-

  1. MySQL
  2. Oracle
  3. MsSQL
  4. PostgreSQL
  5. HyperSQL
  6. MongoDB
  7. Hive
  8. Custom

Datasource tab can be accessed by clicking on Datasource or by clicking on next to the Datasource tab, which will open the Datasource in a new tab. Datasources and other sections under the MasterData tab are only visible if the appropriate privileges have been assigned to the logged in user, please contact your administrator if you facing difficulties accessing the sections under the MasterData tab.

The primary purpose of the Datasource section to perform different functionalities related to reports such as: