Sara,
thanks for that.
If you had to do it again would you use BCI ?
Its seems verbose but expect that its as you say a matter of getting used to
it.
I was hoping for something simple like generating a one line query and
putting the results into a file.
jak
----- Original Message -----
From: "Sara Burns" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Tuesday, July 22, 2008 3:15 PM
Subject: [U2] Getting daily data from SAP from Universe
We do this with both Oracle and SQLServer using the BCI. We have
UniVerse on Red Hat Linux and use OpenLink as our ODBC Manager. This
resides on the Linux server for Oracle and on an NT Server for
SQLServer.
You simply connect to the database, create the SQL queries and then
process the results. This is a quite different technique from that
usually used in UniVerse but once you get used to it, quite easy. I am
assuming the SAP database is SQL compliant.
We also write extensively to Oracle both to a CRM system and to staging
tables for our Data Warehouse.
Sara Burns
Sara Burns (SEB)
IS Development Manager
Public Trust
Phone: +64 (04) 978 4534 (DDI)
Mobile: 029 978 4534
<mailto:[EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]> >
The information contained in this communication (including any attachment)
is
confidential. If you are not the intended recipient, please destroy this
communication. You must not disclose, copy or use in any way the
information
contained in this communication. Any views expressed in this communication
are
not necessarily the views of Public Trust. No representation is made that
this
communication is free of error, virus or interference.
-------
u2-users mailing list
[email protected]
To unsubscribe please visit http://listserver.u2ug.org/
-------
u2-users mailing list
[email protected]
To unsubscribe please visit http://listserver.u2ug.org/
