Informatica Powerconnect?

John McKown

Informatica Powerconnect?
I tried asking this over on IBM-MAIN and got zero (0) responses. So I hope
you don't mind me asking here.

We are apparently going to get Informatica's PowerConnect to run on our
OS/390 system (2.9, if that makes any difference). What we have is a couple
of Sun systems running <whisper> Oracle for a "Data Warehouse" (please, this
was outside of I.T.'s control). This warehouse is fed from our OS/390
system. Now, unfortunately, on OS/390 we do not have any sort of data base
at all. We are 100% "pure" VSAM. At present, data is extracted from the VSAM
files by special purpose COBOL programs. The warehouse users are saying (1)
the data is junk and (2) it is not timely enough when a new extract is
required. For (1) I know that nothing short of auditing the data will fix
this - the data in the VSAM file is junk (on occassion). For (2), they think
that using PowerConnect will allow them do to "ad hoc" SQL SELECTs on the
Sun system to insert data into their <whisper> Oracle data base.

Anyway, has anybody used this product? Do you have any thoughts about its
overhead? Note - recommending a different solution is outside what I can use
because the end-users are driving the boat, not I.T. "Ours is not to wonder
why, ours is but to do or die."

--
John McKown
Senior Technical Specialist
UICI Insurance Center
Applications & Solutions Team
+1.817.255.3225



Rob Barbour

Re: Informatica Powerconnect?
(in response to John McKown)
Hi John,

I dont know much about PowerConnect, so I dont know if this helps you.
But we had someone contact us about HotCopy to send the data to an
Oracle database to supply a Informatica data warehouse.

They were interested in a mainframe to DW vs getting data the other way.
HotCopy automatically takes selected changes (VSAM, DB2, IMS, etc) and
pushes or sends them to other databases, platforms, or images. It can
do data transforms (instead of writing programs) if desired and send
changes immediately, every 'n' minutes/hours, nightly, etc - that may
address the timeliness issue and COBOL extract issues.

See http://www.esaigroup.com/products/delivery.htm for detail.

--
Best Regards,
Rob Barbour
Enterprise Systems Associates, Inc.
Central Florida Research Park
12565 Research Pkwy, Suite 300
Orlando, FL 32826
1-866-GO-4-ESAI
http://www.ESAIGroup.com
Web Enablement... Legacy Integration... Services...

NETPHANTOM - Rapid S/390 & AS/400 Web and Wireless Integration
HOTCOPY - Eliminate Batch FTP Headaches with Intelligent Data Forwarding
BCV4 - Make SAP or DB2 Clone/HSC Available in 15 Minutes
Browser-Based Terminal Emulation - Save on Software Maintenance with
TTWeb
Network File Manager - Powerful File Distribution Technology

"McKown, John" wrote:
>
> I tried asking this over on IBM-MAIN and got zero (0) responses. So I hope
> you don't mind me asking here.
>
> We are apparently going to get Informatica's PowerConnect to run on our
> OS/390 system (2.9, if that makes any difference). What we have is a couple
> of Sun systems running <whisper> Oracle for a "Data Warehouse" (please, this
> was outside of I.T.'s control). This warehouse is fed from our OS/390
> system. Now, unfortunately, on OS/390 we do not have any sort of data base
> at all. We are 100% "pure" VSAM. At present, data is extracted from the VSAM
> files by special purpose COBOL programs. The warehouse users are saying (1)
> the data is junk and (2) it is not timely enough when a new extract is
> required. For (1) I know that nothing short of auditing the data will fix
> this - the data in the VSAM file is junk (on occassion). For (2), they think
> that using PowerConnect will allow them do to "ad hoc" SQL SELECTs on the
> Sun system to insert data into their <whisper> Oracle data base.
>
> Anyway, has anybody used this product? Do you have any thoughts about its
> overhead? Note - recommending a different solution is outside what I can use
> because the end-users are driving the boat, not I.T. "Ours is not to wonder
> why, ours is but to do or die."
>
> --
> John McKown
> Senior Technical Specialist
> UICI Insurance Center
> Applications & Solutions Team
> +1.817.255.3225
>
>
>



John Lorance

Re: Informatica Powerconnect?
(in response to Rob Barbour)
Hi,
we are using this to extract db2 data. Support was
hard to get in the beginning. Like the previous, the
business made the decision before we had time to
review the tech specs.

Do you know if it can read the DB2 Log to get changes?


Thanks
John

--- Rob Barbour <[login to unmask email]> wrote:
> Hi John,
>
> I dont know much about PowerConnect, so I dont know
> if this helps you.
> But we had someone contact us about HotCopy to send
> the data to an
> Oracle database to supply a Informatica data
> warehouse.
>
> They were interested in a mainframe to DW vs getting
> data the other way.
> HotCopy automatically takes selected changes (VSAM,
> DB2, IMS, etc) and
> pushes or sends them to other databases, platforms,
> or images. It can
> do data transforms (instead of writing programs) if
> desired and send
> changes immediately, every 'n' minutes/hours,
> nightly, etc - that may
> address the timeliness issue and COBOL extract
> issues.
>
> See http://www.esaigroup.com/products/delivery.htm
> for detail.
>
> --
> Best Regards,
> Rob Barbour
> Enterprise Systems Associates, Inc.
> Central Florida Research Park
> 12565 Research Pkwy, Suite 300
> Orlando, FL 32826
> 1-866-GO-4-ESAI
> http://www.ESAIGroup.com
> Web Enablement... Legacy Integration... Services...
>
> NETPHANTOM - Rapid S/390 & AS/400 Web and Wireless
> Integration
> HOTCOPY - Eliminate Batch FTP Headaches with
> Intelligent Data Forwarding
> BCV4 - Make SAP or DB2 Clone/HSC Available in 15
> Minutes
> Browser-Based Terminal Emulation - Save on Software
> Maintenance with
> TTWeb
> Network File Manager - Powerful File Distribution
> Technology
>
> "McKown, John" wrote:
> >
> > I tried asking this over on IBM-MAIN and got zero
> (0) responses. So I hope
> > you don't mind me asking here.
> >
> > We are apparently going to get Informatica's
> PowerConnect to run on our
> > OS/390 system (2.9, if that makes any difference).
> What we have is a couple
> > of Sun systems running <whisper> Oracle for a
> "Data Warehouse" (please, this
> > was outside of I.T.'s control). This warehouse is
> fed from our OS/390
> > system. Now, unfortunately, on OS/390 we do not
> have any sort of data base
> > at all. We are 100% "pure" VSAM. At present, data
> is extracted from the VSAM
> > files by special purpose COBOL programs. The
> warehouse users are saying (1)
> > the data is junk and (2) it is not timely enough
> when a new extract is
> > required. For (1) I know that nothing short of
> auditing the data will fix
> > this - the data in the VSAM file is junk (on
> occassion). For (2), they think
> > that using PowerConnect will allow them do to "ad
> hoc" SQL SELECTs on the
> > Sun system to insert data into their <whisper>
> Oracle data base.
> >
> > Anyway, has anybody used this product? Do you have
> any thoughts about its
> > overhead? Note - recommending a different solution
> is outside what I can use
> > because the end-users are driving the boat, not
> I.T. "Ours is not to wonder
> > why, ours is but to do or die."
> >
> > --
> > John McKown
> > Senior Technical Specialist
> > UICI Insurance Center
> > Applications & Solutions Team
> > +1.817.255.3225
> >
> >
> > To change your subscription options or to cancel
> your subscription visit the DB2-L webpage at
> http://listserv.ylassoc.com. The owners of the list
> can be reached at
> [login to unmask email]
>
>
> To change your subscription options or to cancel
> your subscription visit the DB2-L webpage at
> http://listserv.ylassoc.com. The owners of the list
> can be reached at
[login to unmask email]


=====
John Lorance
Database Administrator

Royal and Sunalliance
Charlotte, NC

__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com



Mike Sigal

Re: Informatica Powerconnect?
(in response to John Lorance)
John,

If your data is indeed bad, other issues such as overhead on OS/390
really do not matter - who needs a low overhead system that delivers
junk data?

Most likely, no tool will help you by itself - you need a Data
Warehousing/ Data Cleansing crew to figure out the best way to deliver
clean and timely data to your users. As far as ETL tools go,
Informatica is very good functionally, but again a tool is only a part
of the solution.

Good luck,

Mike Sigal
CTO
Data Mining Solutions, Inc.
[login to unmask email]

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email]
On Behalf Of McKown, John
Sent: Friday, December 13, 2002 10:11 AM
To: [login to unmask email]
Subject: Informatica Powerconnect?

I tried asking this over on IBM-MAIN and got zero (0) responses. So I
hope
you don't mind me asking here.

We are apparently going to get Informatica's PowerConnect to run on our
OS/390 system (2.9, if that makes any difference). What we have is a
couple
of Sun systems running <whisper> Oracle for a "Data Warehouse" (please,
this
was outside of I.T.'s control). This warehouse is fed from our OS/390
system. Now, unfortunately, on OS/390 we do not have any sort of data
base
at all. We are 100% "pure" VSAM. At present, data is extracted from the
VSAM
files by special purpose COBOL programs. The warehouse users are saying
(1)
the data is junk and (2) it is not timely enough when a new extract is
required. For (1) I know that nothing short of auditing the data will
fix
this - the data in the VSAM file is junk (on occassion). For (2), they
think
that using PowerConnect will allow them do to "ad hoc" SQL SELECTs on
the
Sun system to insert data into their <whisper> Oracle data base.

Anyway, has anybody used this product? Do you have any thoughts about
its
overhead? Note - recommending a different solution is outside what I can
use
because the end-users are driving the boat, not I.T. "Ours is not to
wonder
why, ours is but to do or die."

--
John McKown
Senior Technical Specialist
UICI Insurance Center
Applications & Solutions Team
+1.817.255.3225



the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list
can