Re: [U2] Getting daily data from SAP from Universe {Unclassified}
Mike, that was the gotha i was looking for At least now i know what i am up against jak - Original Message - From: HENDERSON MIKE, MR [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Wednesday, July 23, 2008 9:57 AM Subject: RE: [U2] Getting daily data from SAP from Universe {Unclassified} John 2nd problem is actually getting access to SAP table names, data definitions etc. As I understand it, the SAP Table names are in SAP (German) code, and the column names are in SAP code. Then there is another set of tables - also named in SAP code, of course - which provide translations between the SAP column names and insert name of your installed language(s). Oh, yes, it's as complicated as heck. That's how SAP consultants make all their money, and why you need them. The data may be more easily accessible in something like SAP BW, provided you bought that. The only known I have at the moment is that they can send me spreadsheets Which are possibly produced by a point-and-click GUI, so the user will have no idea of the underlying data structures. Or by some customised ABAP reporting, see 'SAP Consultants' above. The easiest and most cost effective mechanism may even be to read in, parse and consume the spreadsheets. Sorry Regards Mike The information contained in this Internet Email message is intended for the addressee only and may contain privileged information, but not necessarily the official views or opinions of the New Zealand Defence Force. If you are not the intended recipient you must not use, disclose, copy or distribute this message or the information in it. If you have received this message in error, please Email or telephone the sender immediately. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Getting daily data from SAP from Universe
John, you can create one generic routine that can execute any BCI query. I could probably dig one out given a bit of notice (next week, when I get home from Japan). Call is something like: RESULT = BCI(DSN, USERID, PASSWORD, SQLQUERY) --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Getting daily data from SAP from Universe
Ray, that would be appreciated At the moment i am hesitating on going down this path as its seems like a redundant technology given its verbosity Also a bit of a learning curve compared to say making Universe accessible to SQL queries . 2nd problem is actually getting access to SAP table names, data definitions etc. The only known i have at the moment is that they can send me spreadsheets but i dont like this as a solution for daily data. jak - Original Message - From: Ray Wurlod [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Tuesday, July 22, 2008 5:16 PM Subject: Re: [U2] Getting daily data from SAP from Universe John, you can create one generic routine that can execute any BCI query. I could probably dig one out given a bit of notice (next week, when I get home from Japan). Call is something like: RESULT = BCI(DSN, USERID, PASSWORD, SQLQUERY) --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Getting daily data from SAP from Universe {Unclassified}
John 2nd problem is actually getting access to SAP table names, data definitions etc. As I understand it, the SAP Table names are in SAP (German) code, and the column names are in SAP code. Then there is another set of tables - also named in SAP code, of course - which provide translations between the SAP column names and insert name of your installed language(s). Oh, yes, it's as complicated as heck. That's how SAP consultants make all their money, and why you need them. The data may be more easily accessible in something like SAP BW, provided you bought that. The only known I have at the moment is that they can send me spreadsheets Which are possibly produced by a point-and-click GUI, so the user will have no idea of the underlying data structures. Or by some customised ABAP reporting, see 'SAP Consultants' above. The easiest and most cost effective mechanism may even be to read in, parse and consume the spreadsheets. Sorry Regards Mike The information contained in this Internet Email message is intended for the addressee only and may contain privileged information, but not necessarily the official views or opinions of the New Zealand Defence Force. If you are not the intended recipient you must not use, disclose, copy or distribute this message or the information in it. If you have received this message in error, please Email or telephone the sender immediately. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Getting daily data from SAP from Universe
Marc, looks like it could work but seems like a lot of coding required from the excample in the BCI pdf Do you have an example that suggests otherwise Ideally i would just like to SELECT FIELD FROM FILE; without 50 lines of supporting code that bind, prepare etc jak - Original Message - From: Marc Harbeson [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Wednesday, July 09, 2008 10:14 AM Subject: RE: [U2] Getting daily data from SAP from Universe One acronym: BCI -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of John Kent Sent: Tuesday, July 08, 2008 6:30 PM To: U2Users Subject: [U2] Getting daily data from SAP from Universe Hi all ideally my client would like Universe to interogate SAP, extract data and upload its own database without having to involve the SAP army ie rather not have one side provide a flat file and the other side deconstruct it The only thing i can think of at the moment is use excel as an intermediary such that... run an excel query on sap to load a spreadsheet upload this data into universe via uniobjects Any ideas appreciated jak --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Getting daily data from SAP from Universe
Hi all ideally my client would like Universe to interogate SAP, extract data and upload its own database without having to involve the SAP army ie rather not have one side provide a flat file and the other side deconstruct it The only thing i can think of at the moment is use excel as an intermediary such that... run an excel query on sap to load a spreadsheet upload this data into universe via uniobjects Any ideas appreciated jak --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Getting daily data from SAP from Universe
One acronym: BCI -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of John Kent Sent: Tuesday, July 08, 2008 6:30 PM To: U2Users Subject: [U2] Getting daily data from SAP from Universe Hi all ideally my client would like Universe to interogate SAP, extract data and upload its own database without having to involve the SAP army ie rather not have one side provide a flat file and the other side deconstruct it The only thing i can think of at the moment is use excel as an intermediary such that... run an excel query on sap to load a spreadsheet upload this data into universe via uniobjects Any ideas appreciated jak --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Getting daily data from SAP from Universe
Hi John, doesn't excel query SAP using ODBC? You might be able to do the same directly from UV or in your uniobjects client. Craig --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Getting daily data from SAP from Universe
SAP is using a SQL database. What I've done to automate some of the data sharing is from the Universe side, I have triggers on certain tables that execute SQL statements against our SQL Server databases to do what I need. Inserts, Updates, etc. all work like a charm. I haven't tried it the other way but I gather it would work with OLEDB or even ODBC if I was desperate. Mike Randall, MCP -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of John Kent Sent: Tuesday, July 08, 2008 6:30 PM To: U2Users Subject: [U2] Getting daily data from SAP from Universe Hi all ideally my client would like Universe to interogate SAP, extract data and upload its own database without having to involve the SAP army ie rather not have one side provide a flat file and the other side deconstruct it The only thing i can think of at the moment is use excel as an intermediary such that... run an excel query on sap to load a spreadsheet upload this data into universe via uniobjects Any ideas appreciated jak --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/