Hello JAMIS Community,
I am working on a project where I need to create Power BI reports based on data from JAMIS. To facilitate this, I plan to extract specific tables from JAMIS into an SQL Server database and connect Power BI to SQL for reporting.
Could you help me understand the best practices for this process? Specifically:
What are the recommended methods to extract data from JAMIS into SQL Server?Does JAMIS provide direct access to the database via ODBC/JDBC, or is OData the preferred approach for exporting tables?
thank you!
