Create Info Link from SQL query or from existing data table
I have a report with multiple SQL queries. The queries have multiple tables and joins.
I know I can use 'database' as an option when adding data table, but updating that data table in future is an issue.
Can someone please help -
1. Is there a way to create Info Link from SQL query (basically 1 IL per query) OR
2. Reverse engineer and create Info Link from Data Tables created using SQL queries (JDBC Data Provider).
Looking for a mechanism to automate this process as I have hundreds of queries.
Appreciate any response. Thanks