I think IBM Web Query for I meets all your criteria...


Paul




From: "Andrew Lopez (SXS US)" <Andrew.Lopez@xxxxxxxxxxxxxxxxxx>
To: "midrange-l@xxxxxxxxxxxx" <midrange-l@xxxxxxxxxxxx>
Date: 28/08/2015 14:47
Subject: Querying a Microsoft SQL Server 2012 Database from an
iSeries
Sent by: "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx>



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 thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2019 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].