If you already have SQL Server 2012, why don't you just use it. It can hook into any database on the planet, and you have SSRS available to you as part of your SQL Installation and can do everything you wish except for #1 (running on the IBM i).
With SSRS (SQL Reporting Services), create a report and schedule it to run when you wish and have it email the resulting report as a spreadsheet to your email addresses...
We have several reports that get generated from SSRS that interface with the IBM I and email folks on a regular basis, it isn't hard.
What is even more powerful is when you start exposing your data as SSRS reports, you also expose that data via OData service feeds which has lots of possibilities for end user analytics using Excel and any tool that can consume OData feeds.
Requires no SPENDMONEY or ROLLYOUROWN commands.
From: Andrew Lopez (SXS US) [mailto:Andrew.Lopez@xxxxxxxxxxxxxxxxxx]
Sent: Friday, August 28, 2015 7:48 AM
Subject: Querying a Microsoft SQL Server 2012 Database from an iSeries
Does anyone know of a query tool that meets the following criteria:
- It runs on the IBM i and can be scheduled by Robot
- It can email results as an Excel spreadsheet
- It can query Microsoft SQL Server 2012 and the native database
- It DOES NOT require manually configuring JDBC?
We have the need to generate reports and don't have the time to sort out Java Versions, JDBC jar versions, Class paths, Connection Strings, SSL errors and the rest. If the tool uses JDBC, but handles all of the needed configuration AND supports SQL Server 2012, we would be interested. I can find plenty of information on rolling out solutions using JDBC, but we don't have time for that. I found that ARDGate can handle the JDBC setup in a more automated fashion, but I need a reporting tool that will support pulling the data and sending as indicated above.
The SPENDMONEY command is what we would prefer, the ROLLYOUROWN command will not be used.
Spirax-Sarco Engineering Plc. This e-mail has been scanned for viruses by Verizon Business Internet Managed Scanning Services - powered by MessageLabs. For further information visit http://www.verizonbusiness.com/uk
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/midrange-l