Thanks for the clarification, I've never had a need to interface/integrate anything with SQL Server but fwiw the database perspective uses jdbc via jt400. Maybe I just haven't had that large of a dataset but you can use export all rows to excel and that has done the trick for me. If I ever have the opportunity I may give Quantum a shot, unfortunately "free time" is after hours and since I finally have some after hours I spend that time with the wife ;)
Thanks,
Tommy Holden
-----Original Message-----
From: WDSCI-L [mailto:wdsci-l-bounces@xxxxxxxxxxxx] On Behalf Of Scott Johnson
Sent: Monday, August 22, 2016 7:54 AM
To: Rational Developer for IBM i / Websphere Development Studio Client for System i & iSeries <wdsci-l@xxxxxxxxxxxx>
Subject: Re: [WDSCI-L] List of "need to get" plug ins for RDi
Why Quantum... (at least for me)
Several years ago, I had the need to run SQL and export large datasets to Excel. I tried many plug-ins and none could handle the large datasets. I came across Quantum and it was able to handle the large datasets and export them to Excel. At some point I did try the Database Perspective and it could not handle the datasets either.
To me another good thing about Quantum is that it is quick and dirty. Type in an SQL, click run, get results. If you are a fan of intellisense this is not for you. Oh and you can pretty much connect to any DB with a JDBC driver. Which came in handy when I needed to hit the MS SQL server.
Over the years I have tried different plug-ins that handle SQL and none really caught my fancy.
I tried the recent incarnation of the Database perspective and went back to Quantum. I am just not a fan of how they arrange the Views.
I am keeping an eye Access Client Solutions Run SQL. If this could be fully integrated into RDi...
Thanks,
Scott Johnson
-----Original Message-----
From: WDSCI-L [mailto:wdsci-l-bounces@xxxxxxxxxxxx] On Behalf Of Tommy Holden
Sent: Monday, August 22, 2016 7:34 AM
To: Rational Developer for IBM i / Websphere Development Studio Client for System i & iSeries <wdsci-l@xxxxxxxxxxxx>
Subject: Re: [WDSCI-L] List of "need to get" plug ins for RDi
I confess I haven't used the Quantum plug-in but I have found the database perspective in RDi to work very well so I'm not sure it is truly a "must have" plug-in. but that's just my opinion perhaps others can chime in.
Thanks,
Tommy Holden
-----Original Message-----
From: WDSCI-L [mailto:wdsci-l-bounces@xxxxxxxxxxxx] On Behalf Of Scott Johnson
Sent: Monday, August 22, 2016 7:31 AM
To: Rational Developer for IBM i / Websphere Development Studio Client for System i & iSeries <wdsci-l@xxxxxxxxxxxx>
Subject: Re: [WDSCI-L] List of "need to get" plug ins for RDi
iSphere: {Kitchen Sink}
http://sourceforge.net/projects/isphere/
SoftLanding RSE Extension: {Clean Edit Perspective & Compare}
http://www.softlanding.com/resources/
Quantum: {Quick and dirt SQL}
http://quantum.sourceforge.net/
Thanks,
Scott Johnson
-----Original Message-----
From: WDSCI-L [mailto:wdsci-l-bounces@xxxxxxxxxxxx] On Behalf Of Jim Oberholtzer
Sent: Monday, August 22, 2016 7:03 AM
To: Rational Developer for IBM i / Websphere Development Studio Client for System i & iSeries <wdsci-l@xxxxxxxxxxxx>
Subject: [WDSCI-L] List of "need to get" plug ins for RDi
Folks:
I'm getting questions from customers and colleagues about what plug ins are available for RDi and which ones should be must have. I simply don't do enough application development to use these daily so I'll turn to you folks.
I know it might be different for some folks but that's the beauty of it, it
is not? So Free or Paid, what's the list? (Let's go with compatibility
with the latest release of Rational)
--
Jim Oberholtzer
Agile Technology Architects
--
This is the Rational Developer for IBM i / Websphere Development Studio Client for System i & iSeries (WDSCI-L) mailing list To post a message email: WDSCI-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/wdsci-l
or email: WDSCI-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/wdsci-l.
--
This is the Rational Developer for IBM i / Websphere Development Studio Client for System i & iSeries (WDSCI-L) mailing list To post a message email: WDSCI-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/wdsci-l
or email: WDSCI-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/wdsci-l.
--
This is the Rational Developer for IBM i / Websphere Development Studio Client for System i & iSeries (WDSCI-L) mailing list To post a message email: WDSCI-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/wdsci-l
or email: WDSCI-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/wdsci-l.
--
This is the Rational Developer for IBM i / Websphere Development Studio Client for System i & iSeries (WDSCI-L) mailing list To post a message email: WDSCI-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/wdsci-l
or email: WDSCI-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/wdsci-l.
midrange.com
