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 users.
Instructions
- Ensure that you are using Sisense version 2023.6 or newer. This version has updated frameworks that affect connect visibility.
- 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
- Execute the following command to look for the connectors pod in your environment:
If pod with name starting with ‘connectors’ is present on the environment, it indicates that the Generic JDBC connector is part of the old framework.
- 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.
- 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.
