Resolving Missing Generic JDBC Connector in Sisense

Resolving Missing Generic JDBC Connector in Sisense

This article addresses the issue where the Generic JDBC connector is not visible under available connectors for users logged in with a designer account in Sisense version 2023.6 or newer. This problem arises due to changes in the framework that affect the visibility of certain connectors for non-admin user 

Instructions 

1. Ensure that you are using Sisense version 2023.6 or newer. This version has updated frameworks that affect connect visibility. 
2. Log in using an admin account to confirm that the Generic JDBC connector is visible. Admin accounts have access to all connectors, including those from older frameworks 
3. Execute the following command to look for the connectors pod in your environment: 

1 kubectl -n sisense get pods | grep connectors

If a pod with a name starting with ‘connectors’ is present in the environment, it indicates that the Generic JDBC connector is part of the old framework. 

1. Since the Generic JDBC connector is part of the old framework, it is recommended to migrate all connections to the new framework. This will ensure that all users, including those with designer accounts, can access the necessary connectors. 
2. Re-create all old connectors using the new framework. You can check this article for more information  https://community.sisense.com/t5/knowledge-base/how-to-create-jdbc-connector-on-a-new-framework/ta-p/9598 

Conclusion 

In Sisense version 2023.6 or newer, the Generic JDBC connector may not be visible to non-admin users due to framework updates. Admin users can still access it, and migrating connections to the new framework will resolve visibility issues for all users. Following the steps outlined above will help ensure a smooth transition and maintain access to necessary connectors.