Can I connect a BIRT reporting tool to multiple SQL servers in AIV, and how do I do it?

Yes, it is possible to connect the BIRT reporting tool with two SQL servers. You can achieve this by creating separate data sources for each SQL server. Follow these steps to set it up:

Steps to Connect BIRT to Two SQL Servers:

1. Create Data Sources:

   • Open BIRT and go to Data Explorer.
   • Right-click on Data Sources and choose New Data Source.
   • Configure the connection settings (driver, URL, credentials) for the first SQL server.
   • Repeat the process to add the second SQL server as a separate data source.

2. Create Data Sets:

   • After adding both data sources, right-click on Data Sets and select New Data Set.
   • Choose the first SQL server’s data source and create a query for it.
   • Repeat for the second SQL server, creating a dataset using its corresponding data source.

3. Use Data in Reports:

   • You can use the datasets separately or combine them using joins or separate report sections, depending on your reporting needs.

If you need further assistance, reach out to support@aivhub.com.