Create, Edit, Share & Delete Data Source

In this blog, we will how to connect to a data source in Helical Insight.

Overview of Data Sources Tab

    1. The list of Data sources is present as a collection of icons for each database.
    2. User can search for the data source by typing in the search box.

    1. User can also search based on type of database by clicking on the relevant tabs.

  1. Data source Icons:
    1. If there is a green tick mark on the left hand corner of the data source icon, it implies that the driver for that data source is present in the “Drivers” folder of the “hi-repository”.
    2. If there is no green tick mark on the left-hand corner of the data source icon, it means that the driver for that data source is not present. You will have to add the driver by following the process mentioned here. The driver might not be present because of copy-left license issue. (link to add data source driver)

Add Database Driver:

If the tick icon is present then you can immediately make connection and start using it. If the tick icon is not present please follow the below steps to add drive.

    1. Click on the database that you want to add the driver for.
    2. Click on Download Relevant Database Driver. You will be directed to the website from where the driver needs to be downloaded. Make sure that the driver supports the version on database that you are using.

    1. Once the driver has been downloaded, click on Upload Driver. You will be taken to the File Browser. Select the driver that you have downloaded. The driver should be a jdbc4 .jar or .zip file.

    1. Click on Detect the driver in lib/classpath if the driver is present in the lib/classpath. Helical Insight will detect the driver and automatically upload it in the “Drivers” folder of the server.

  1. Once the driver has been uploaded the specific database icon will also have tick icon. The data source connection can be established now, read on to learn how to make datasource connection.

Create a Data source Connection:

    1. Click on the data source that you want to connect to.

    1. In the “Create” tab, enter the following details:
      1. Host: Enter the server details or IP where the database resides.
      2. Port: Enter the port number to connect to your database server.
      3. Database Name: Enter the name of your database.
      4. User Name: Enter the username credential if required to access your database.
      5. Password: Enter the password credential if required to access your database.
      6. Data Source Name: Enter a name of your choice to the data source connection.

    1. Advanced: If you have any advanced settings required to access your database, click on “Advanced” link at the top right corner of the Create Tab. The additional fields are:
      1. Other Options: Enter the properties that are required additionally apart from the Host IP and Port to access the database. E.g.: ?ssl=true. Click on Advanced in order to make advanced level settings like adding properties apart from host and port, changing the data source provider etc. You can use the other options to restrict the tables that will be exposed at the metadata level
        Using the advanced options you can also do prefiltering of what all things to show at the metadata level. This prefiltering can happen at tables, columns and schemas:

        ?HI_SCHEMA_CONTAINS=hi (this will show only the schema names that contain the string hi)
        ?HI_CATALOG_CONTAINS=t (this will show only the catalog names that contain t)
        ?HI_CATALOG=travel_data (this will show only travel_data catalog)

        Similar strings and regular expression (regex) can be used to restrict the database tables, schema, cataglos that are visible at the metadata level.

        So with above method you can initially restrict the size of listing on the metadata page so that it is fast and make initial metadata. Then you can edit the already created datasource to include other table/schema (using the above mentioned method), then edit the metadata created earlier (refresh the cache) and then select additional tables required and make it part of the metadata by using the merge option. This way your create-metadata browser page will never be so heavy and will work fine.
      2. URL: This field shows the URL that is generated to create the JDBC connection. This can be used to verify if the properties are sufficient to access the database.
      3. Driver: This field shows the driver that is being used to establish the connection. It can be changed if required.
      4. Datasource: This is the name of the datasource provider. By default it is Tomcat. It can be changed, if required.

    1. Once all the details have been filled, click on Test Connection.

  1. If the test is successful, click on Save Data Source to save the data source connection.

The Data Source is successfully created. You can now use this data source to:

As soon as a data source connection is established, the cache starts getting prepared for use at metadata level. This cache contains the list of schema, catalogs and tables present in the data source. This helps in faster performance at the metadata level.

View Data Source:

When data source connections for a particular database are already available, you will be taken to “View” tab when you click on the database name. A list of data source connections that have been created for that database will appear.

  • Search: User can search a particular connection within the list.
  • User can sort the connections depending on Name and Connection ID.
  • Test: Click on this button to test the connection.
  • Edit: Click on this button to edit the data source connection.
  • Share: Click on this button to share the data source connection with other users.
  • Delete: Click on this button to delete the data source connection.
  • Create Metadata: Click on this button to create a metadata from the connection. It is advisable to test the connection before creating metadata.

Edit Data Source:

    1. Go to the Data Sources tab next to Home.
    2. Click on the database icon that contains the connection you want to edit. You will see a list of connections that are present for that database.

    1. Click on the Edit button corresponding to the connection that you want to edit. You will see the connection details.
    2. Input the details that you want to edit.

    1. Click on Advanced in order to make advanced level settings like adding properties apart from host and port, changing the data source provider etc.

    1. Click on Test Connection.

    1. If Test is successful, click on Update Datasource in order to save the changes that you have made.

  1. The data source connection has been updated successfully. You can now:
    1. Create Metadata using this data source
    2. Edit the data source
    3. Share the data source

Share Data Source:

    1. Click on Data Sources tab next to Home tab.
    2. Click on the database in which the data source that you want to share resides. You will see the list of data sources available.

    1. Click on Share button corresponding to the data source connection you want to share. A screen with the Share Options will appear. There are 3 tabs on this Screen:
      1. Users: This is a list of all the users that have been defined in the Home screen under User Management Tab. If you want to share the data source details only with a particular user or if you want to change the permission level for a particular user within an organization, select the user and set the permission level.
      2. Roles: This is a list of all the roles that have been defined in the Home screen under Roles Tab. If you want to share the data source connection details with all users having a particular role, use this option to set the permissions.
      3. Organizations: This is a list of all the organizations defined in the Home screen under Organizations Tab. If you want to share the data source connection with all the users of a particular organization, you can achieve it by using this tab.

    1. Click on the check box next to the user/role/organization that you want to give the permission for.

    1. Set the permission level for the particular user/role/organization. The following permission levels are available:
      1. No Access: This level is used to deny access to a particular user, role or organization.
      2. Execute Only: This level will give only execution rights to the user, role or organization. The user will not be able to see the data source connection details but will be able to retrieve the data. Hence, if you want the users to only view the report/dashboard while not being able to view the data source details, use this particular option.
      3. Read Only: This level will give Read only access to the user, role or organization. The user can only read the data source details.
      4. Read + Write: This level will give Read + Write access to the user, role or organization.
      5. Read + Write + Delete: This level will give Read + Write + Delete access to the user, role or organization.
      6. Read + Write + Delete + Share: This level will give Read + Write + Delete + Share access to the user, role or organization.

  1. Once you have made the necessary changes, click on Share button. The data source will be shared.

Please note that the user level permissions will override the organization level permissions. Hence, if you want to give different permission to a particular user in an organization, you can set the organization permission level according to the general permission levels in the Organizations tab and then modify the permission level for a particular user in the Users tab.

Delete Datasource:

    1. Click on Data Sources tab next to Home tab.
    2. Click on the database in which the data source that you want to delete resides. You will see the list of data source connections that have been created.
    3. Click on Delete button corresponding to the data source connection you want to delete. You will get 2 options:
        • Simple Delete:Select this option to delete the data source connection only.
        • Cascaded Delete:Selecting this option will delete all the Metadata, Reports and Dashboards associated with this datasource connection.

    4. Select the type of delete. You will be prompted to confirm your action. Click on OK.

The datasource connection is deleted.

Add New Database:

Helical Insight supports a variety of databases, it also gives you the flexibility of adding all together a new DB even if it is not present in the list. If your database is not found in the list that comes out-of-the-box, you can add the driver by following the process given below:

    1. Click on “Add Driver” icon present at the bottom of the data sources list.

Adding Database

    1. Click on “Download the relevant database driver” in order to download the driver for the database that you want to connect to.

Adding New Database

    1. Download the database jdbc driver in .jar/.zip format.
    2. Click on “Upload driver”. You will be taken to the file browser. Select the driver that you have downloaded. Your driver will be uploaded.

Adding New Database

  1. A new database icon will be generated with the name of the database. You can now create your data source connection for the newly added data source.

Adding New Database

For more information you can email on support@helicalinsight.com

You May Also Like

Helical Insight’s self-service capabilities is one to reckon with. It allows you to simply drag and drop columns, add filters, apply aggregate functions if required, and create reports and dashboards on the fly. For advanced users, the self-service component has ability to add javascript, HTML, HTML5, CSS, CSS3 and AJAX. These customizations allow you to create dynamic reports and dashboards. You can also add new charts inside the self-service component, add new kind of aggregate functions and customize it using our APIs.
Helical Insight’s self-service capabilities is one to reckon with. It allows you to simply drag and drop columns, add filters, apply aggregate functions if required, and create reports and dashboards on the fly. For advanced users, the self-service component has ability to add javascript, HTML, HTML5, CSS, CSS3 and AJAX. These customizations allow you to create dynamic reports and dashboards. You can also add new charts inside the self-service component, add new kind of aggregate functions and customize it using our APIs.
Helical Insight, via simple browser based interface of Canned Reporting module, also allows to create pixel perfect printer friendly document kind of reports also like Invoice, P&L Statement, Balance sheet etc.
Helical Insight, via simple browser based interface of Canned Reporting module, also allows to create pixel perfect printer friendly document kind of reports also like Invoice, P&L Statement, Balance sheet etc.
If you have a product, built on any platform like Dot Net or Java or PHP or Ruby, you can easily embed Helical Insight within it using iFrames or webservices, for quick value add through instant visualization of data.
If you have a product, built on any platform like Dot Net or Java or PHP or Ruby, you can easily embed Helical Insight within it using iFrames or webservices, for quick value add through instant visualization of data.
Being a 100% browser-based BI tool, you can connect with your database and analyse across any location and device. There is no need to download or install heavy memory-consuming developer tools – All you need is a Browser application! We are battle-tested on most of the commonly used browsers.
Being a 100% browser-based BI tool, you can connect with your database and analyse across any location and device. There is no need to download or install heavy memory-consuming developer tools – All you need is a Browser application! We are battle-tested on most of the commonly used browsers.
We have organization level security where the Superadmin can create, delete and modify roles. Dashboards and reports can be added to that organization. This ensures multitenancy.
We have organization level security where the Superadmin can create, delete and modify roles. Dashboards and reports can be added to that organization. This ensures multitenancy.
We have organization level security where the Superadmin can create, delete and modify roles. Dashboards and reports can be added to that organization. This ensures multitenancy.
We have organization level security where the Superadmin can create, delete and modify roles. Dashboards and reports can be added to that organization. This ensures multitenancy.
A first-of-its-kind Open-Source BI framework, Helical Insight is completely API-driven. This allows you to add functionalities, including but not limited to adding a new exporting type, new datasource type, core functionality expansion, new charting in adhoc etc., at any place whenever you wish, using your own in-house developers.
A first-of-its-kind Open-Source BI framework, Helical Insight is completely API-driven. This allows you to add functionalities, including but not limited to adding a new exporting type, new datasource type, core functionality expansion, new charting in adhoc etc., at any place whenever you wish, using your own in-house developers.
It handles huge volumes of data effectively. Caching, Pagination, Load-Balancing and In-Memory not only provides you with amazing experience, but also and does not burden the database server more than required. Further effective use of computing power gives best performance and complex calculations even on the big data even with smaller machines for your personal use. Filtering, Sorting, Cube Analysis, Inter Panel Communication on the dashboards all at lightning speed. Thereby, making best open-source Business Intelligence solution in the market.
It handles huge volumes of data effectively. Caching, Pagination, Load-Balancing and In-Memory not only provides you with amazing experience, but also and does not burden the database server more than required. Further effective use of computing power gives best performance and complex calculations even on the big data even with smaller machines for your personal use. Filtering, Sorting, Cube Analysis, Inter Panel Communication on the dashboards all at lightning speed. Thereby, making best open-source Business Intelligence solution in the market.
With advance NLP algorithm, business users simply ask questions like, “show me sales of last quarter”, “average monthly sales of my products”. Let the application give the power to users without knowledge of query language or underlying data architecture
With advance NLP algorithm, business users simply ask questions like, “show me sales of last quarter”, “average monthly sales of my products”. Let the application give the power to users without knowledge of query language or underlying data architecture
Our application is compatible with almost all databases, be it RDBMS, or columnar database, or even flat files like spreadsheets or csv files. You can even connect to your own custom database via JDBC connection. Further, our database connection can be switched dynamically based on logged in users or its organization or other parameters. So, all your clients can use the same reports and dashboards without worrying about any data security breech.
Our application is compatible with almost all databases, be it RDBMS, or columnar database, or even flat files like spreadsheets or csv files. You can even connect to your own custom database via JDBC connection. Further, our database connection can be switched dynamically based on logged in users or its organization or other parameters. So, all your clients can use the same reports and dashboards without worrying about any data security breech.
Our application can be installed on an in-house server where you have full control of your data and its security. Or on cloud where it is accessible to larger audience without overheads and maintenance of the servers. One solution that works for all.
Our application can be installed on an in-house server where you have full control of your data and its security. Or on cloud where it is accessible to larger audience without overheads and maintenance of the servers. One solution that works for all.
Different companies have different business processes that the existing BI tools do not encompass. Helical Insight permits you to design your own workflows and specify what functional module of BI gets triggered
Different companies have different business processes that the existing BI tools do not encompass. Helical Insight permits you to design your own workflows and specify what functional module of BI gets triggered