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



(1) Answer