I am attempting to do write an automation script to compare the results of two queries, one executing against DB2 and the other against SQL Server. In running on my local machine, I followed these steps, and got it to work.
- Insert results of DB2 Query into a table on Local Storage
- Insert results of SQL Query into a different table on Local Storage
- Compare the contents of the two Local Storage tables and generate a report of the differences
When I tried to publish this to Intelligence Central, I received an error, as Local Storage is not valid for Intelligence Central. I changed Local Storage output to Intelligence Central outputs (the only options are Local Storage and Intelligence Central). This works for steps 1 and 2, but not for step 3. I am unable to chose an Intelligence Central connection as input for Data Compare. Am I supposed to be able to use Intelligence Central objects as an input for Compare?
If not - then how would you recommend I change my approach?