Skip to Content

After the release of the Data Federator SQL Do you want to query SAP BW using SQL?, we wanted to go a step further and query directly the ERP using the same technology.

We worked with the Paris labs team to extend our connector and deliver a prototype helping you to create ad-hoc WebI reports on top of the SAP ERP. You can get more details and download the prototype SAP BusinessObjects Web Intelligence Reporting for SAP ERP.

This prototype queries the ERP using RFC functions but we are looking for feedbacks on how to improve and add features which could add value to your business.

Feel free to contact us with ideas and use cases which could be valuable for your business.

Thanks in advance,

Fred

To report this post you need to login first.

15 Comments

You must be Logged on to comment or reply to a post.

  1. Former Member
    This connector is really helpful!

    I have couple of questions:

    1)What is the planned release date for the connector to be used in a Production environment?

    2)Are there any plans to extend the connector functionality to query R/3 tables or SAP Infosets similar to the Crystal reports connector?

    Thanks.

    Deepu

    (0) 
    1. Former Member
      Post author
      Deepu

      We are working to improve the prototype to support Infoset and get more feedbacks from our customers.

      I cannot communicate publically about future release dates.

      Fred

      (0) 
      1. Former Member
        I have DF installed with XI 3.0 SP1 FP2, while applying the Fix pack 8 from the attachment I got an error saying that I do not have the correct version of the DF software to apply Fix Pack 8.

        Should I be on a newer fix pack inorder to apply Fix pack 8? I could not find anything else in SMP for Windows 64 bit.

        Thanks.

        (0) 
        1. Former Member
          Post author
          Hi

          FP8 supports only DF XI 3.0 SP1 and DF XI 3.0 SP1 Fix Pack 1

          I will check with the engineering team and see how we can improve the situation.

          Sorry about that,

          Fred

          (0) 
  2. Former Member
    Hi all,
    this is exactly what we are looking for.
    We actually use Universes in WebI to query BW. At the moment we are looking to get data from ERP, doesn’t matter tables or RFC functions.
    Could you say anything about the release plan.
    Thanks and best regards
    (0) 
    1. Former Member
      Post author
      Oliver

      Excellent news, drop me an email as we are looking for customers who want to test this prototype before to implment the final product.

      We are working on the version 2 of the prototype (probably released in Nov 09) to support the ERP Infoset and the last version of Data Federator.

      The plan is to productize it in 2010.

      (0) 
      1. Former Member
        Hi Frederic,

        Do you have any details on when (approx. date and product version) this will be available for production usage?

        Thanks.

        Deepu

        (0) 
  3. Former Member
    I need to read more than one cube from BW as data source and use both 2 cubes in one universe can I do this because I found an article that use only one cube

    Thanks

    (0) 
    1. Former Member
      Post author
      Mohamed

      The strategy used to generated automatically the Universe (data foundation + business layer) supports only supports only one infoprovider (Infocube, Multiprovider or DSO).

      However nothing prevent you to connect to multiple infoprovider manually in the Universe.

      The team is working to update the Universe strategy to support multiple infoproviders.

      Hope this helps,

      Fred

      (0) 
      1. Former Member
        Hi Frederic,
                  Is it possible to connect Desktop Intelligence Reports on top of Data Federator universe. If so please help what should i follow to connect the DF universe with Deski reports.
        Thanks,
        Murali.
        (0) 
  4. Former Member
    Frederic,

    It appears as though the DF always maps a DEC ABAP data type to a string data type when creating a data source from an RFC function.  The issue I’m finding with this is that when trying to use the conversion function ToDecimal or ToDouble in DF, I’m getting an error stating that a VARCHAR cannot be converted to type DECIMAL.  Any help you can provide?

    Thanks,
    Chad

    (0) 

Leave a Reply