What is Datasource and why it is needed in Helical Insight (HI)A data source is a location from which the data required for creating a report is fetched. The data may be stored in databases, csv files, excel sheets, etc. at different locations or accessed through different applications requiring their own drivers. For this reason, HI needs to connect to these data sources, by providing the location of the data source and its access credentials.
How to connect to a DataSources based on Report TypeIn Helical Insight we have 2 types reports are created
- EFW Reports
- Adhoc Reports
EFW Reports: In EFW reports, the connection details are provided in the “.efwd” files inside the “<connection>” tag which is placed inside “<DataSources>” tag.
- <Driver> : The driver for the data source being used.
- <Url> : Location of the Data Source on the Server.
- <User> : Username for logging into the Data Source.
- <Pass> : The password for the Data Source.