I am using the cdata ODBC driver to try to connect to our Jira cloud, but I am faced with this everytime I try to view a table when connecting with Excel
DataSource.Error: ODBC: ERROR [HY000] You are not authorized for this operation.
Details:
DataSourceKind=Odbc
DataSourcePath=dsn=CData JIRA Source
OdbcErrors=[Table]
I seem to be connected OK and I see the various items in the JIRA tree but any attempts to view, results in the above.
In the ODBC set up I am using the API key generated using admin.atlassian.com
Any help appreciated