Re: Querying a Microsoft SQL Server 2012 Database from an iSeries

SEQUEL can do this - other query products like NGS-IQ probably do - another poster mentioned IBM Web Query.

Does ArdGate turn the connectivity into DRDA connections, basically? Then you could use any of the tools such as SEQUEL, since they can use the RDB directory entries to your advantage, as they think it's all DB2 (kind of!)

Not sure how much JDBC stuff is OK with you - you will have to specify the driver and connection details- no way around that that I know of. SEQUEL gives you the ability to name a connection with user id and password and connection strings and a couple other details - one-time operation. Other products probably have similar - we have SEQUEL, so I know that a little better.

HTH
Vern

On 8/28/2015 7:47 AM, Andrew Lopez (SXS US) wrote:

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