Resolving Limited Column Retrieval in Sisense API Connection to Jira
Summary: Vlad Solodkyi raised an issue about retrieving limited columns when connecting Sisense API to Jira, seeking solutions to improve data extraction.
Summary
This article addresses the issue where a Sisense API connection to Jira only retrieves native columns and does not include custom column fields. It provides a step-by-step solution to resolve this issue and ensure that custom field columns are retrieved.
Main Content
Step-by-Step Instructions to Resolve Limited Column Retrieval
Identify the Connector:
Ensure you are using the correct connector for your Jira data source. In this case, the CData Jira ServiceDesk connector is used.
Check JDBC String Parameters:
Verify that the JDBC string parameters are correctly set. Specifically, ensure that the IncludeCustomFields parameter is set to true to ensure that custom fields columns are retrieved.
Example JDBC string: jdbc:cdata:jira:URL=https://your-jira-instance;IncludeCustomFields=true;
Review Connector Settings:
Check the settings of the CData Jira ServiceDesk connector to ensure there are no configurations that limit the retrieval of custom columns.
Refer to the CData documentation for more details: CData Jira JDBC Connection
Verify Data Retrieval:
After updating the JDBC string and reviewing the connector settings, re-run your data retrieval process to ensure that custom field columns are now being retrieved along with the native columns.
Troubleshooting Tips
Verify Connector Compatibility:
Ensure that the connector you are using is compatible with the version of Jira and Sisense you are running.
Check for Updates:
Make sure that both Sisense and the CData connector are up to date to avoid any compatibility issues.
Consult Documentation:
Refer to the official documentation for both Sisense and the CData connector for any additional configuration settings that might affect column retrieval.
Additional Information
Community Resources:
If you continue to experience issues, consider consulting the Sisense community forums or the CData support resources for further assistance.
By following these steps, you should be able to resolve the issue of limited column retrieval in your Sisense API connection to Jira. If you have any further questions or encounter additional issues, please create a separate support ticket with detailed information about the problem.
