Deleting a datasource

I have created multiple datasources using Adhoc datasource option. I want to delete. How to do it ?

This can be done from backend. Go to the repository where Helical Insight is installed.

Example :Suppose you have installed Helical Insight in “C:\Helical Insight”. Then open “hi-repository” and then “System” and then “Admin”. Thus the path could look something like “C:\Helical Insight\hi-repository\System\Admin” . In this there is a file called “globalConnections”. Open this file and you can delete the datasource.

For example in my case I have deleted hikaridatasource which has been created by deleting the below text

    <dataSourcePoolId>hikari_1</dataSourcePoolId>

    <dataSourceProvider>hikari</dataSourceProvider>

    <maximumPoolSize>100</maximumPoolSize>

    <minimumIdle>1</minimumIdle>

    <maxLifetime>3600000</maxLifetime>

    <userName>hiuser</userName>

    <password>hiuser</password>

    <poolName>hikari_mysql_1</poolName>

    <connectionTestQuery>SELECT 1</connectionTestQuery>

    <driverName>com.mysql.jdbc.Driver</driverName>

    <jdbcUrl>jdbc:mysql://localhost:3307/SampleTravelData</jdbcUrl>

</hikariDataSource>

Delete it and save the file.

Note : Please note after deletion reports which are using this datasource will stop working.eh

Regards,
Helical Insight Team