Loading data from BI to SQL Server...

[Former Member]

Hi

I want to load data from BI to SQL Server but don't want to use Open Hub Service. Could you pls suggest me any other method?

Thanks in Advance...

[Former Member]

thanks

[Former Member]

Hi,

Analysis Process Designer

Use

In SAP BW, data from various databases from systems available in the company are collected, consolidated, managed and prepared for evaluation purposes. There is often further, valuable potential in this data.

It deals with completely new information that is displayed in the form of meaningful connectivity between data but that is too well hidden or complex to be discovered by simple observation or intuition.

The Analysis Process Designer (APD) makes it possible to find and identify these hidden or complex relationships between data in a simple way. Various data transformations are provided for this purpose, such as statistical and mathematical calculations, and data cleansing or structuring processes.

The analysis results are saved in BW data targets or in a CRM system. They are available for all decision and application processes and thus can be decisive (strategically, tactically, operatively).

Examples of analysis processes include the calculation of ABC classes, determination of frequency distribution or of scoring information.

For more info go through the below link

http://help.sap.com/SAPHELP_ERP2004/helpdata/EN/49/7e960481916448b20134d471d36a6b/content.htm

Regards,

Marasa.

[former_member181964]

Hi,

It seems to be year back I implemented the same see the blog i=on the same. It is working 100%.

https://wiki.sdn.sap.com/wiki/display/profile/Surendra+Reddy

How to transfer the Data from SAP-System to Non-SAP system without additional Cost/License

/people/surendrakumarreddy.koduru/blog/2009/03/11/how-to-transfer-the-data-from-sap-system-to-non-sap-system-without-additional-costlicense

Thanks

Reddy

[Former Member]

Dear Surendra

Thanks for your reply. In your response you made the assumption:

Source : SAP-BW System running on UNIX.

Destination : SQL-Server running on Windows XP.

But my case is Both (BW & SQL Server ) are on Windows 2008. Now could you pls give me solution considering these environments.

In waiting of your reply.

Thanks

Harpal

[Former Member]

Hi Harpal,

check out these three links:

http://www.microsoft.com/isv/sap/technology/webcasts.aspx and look for "Microsoft Business Intelligence for SAP Netweaver". This Webcast gives a good overview of the several ways of connecting SAP to Microsoft technology.

Here you can find information about the Microsoft Connector for SAP BI. (However I have not tried this out myself yet)

http://msdn.microsoft.com/en-us/library/dd433138.aspx

Using SQL Server 2008 Integration Services with SAP BI 7.0: http://msdn.microsoft.com/en-us/library/dd299430.aspx

Hope this helps.

Regards

Christoph

Edited by: Christoph Außem on Nov 23, 2009 2:29 PM

[Former Member]

My assumption is that the interface will be build on flat files and the question is how to obtain these.

APD allows to write data from BW infoproviders to flat files. You can implement logic you need or just spool the data and automate the procedure with process chains (i.e. using standard methods).

Then import the files into SQL Server, also automating the process.

[Former Member]

Analysis Process Designer?

[Former Member]

Hi Marcin

Sorry to tell you the version i m using is BI 7.0.

Could you pls. briefly let me know how APD (Analysis process Designer) can help me in achieving the data load from BI -> SQL Server?

Thank You Very much for your effort !

[Former Member]

Hi

Can anyone help me in finding the way to load data into SQL Server from BI without using Open Hub Service.

As mentioned by Marcin that i can even use ''Analysis Process Designer (APD)" for this purpose. Could u pls. explain me what would be role of APD in the required scenario.

And if think some other way too, Pls let me know.

Thank You

Harpal