Skip to Content
avatar image
Former Member

multisource relational connection in IDT

Hi,

I'm trying to create a relational connection when i want to connect to SAP BW  as a middleware driver.But when i Try to create connection i can't see this connection type under SAP.

Is there is any setup required to enable this ?

Please find the attachment for the description.

Thanks in advance

-Regards

  B

SAP_Conn.JPG (30.8 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Apr 30, 2012 at 02:48 PM

    Hi,

    The cause might be that you have have seleceted local resources. But SAP BW is not available as a local resource. You have to log on to the Reporsitory reources pane in the following way

    1) Log on to IDT

    2) Create a new project

    3) Login to REpository resources pane

    4) CLick on the green plus sign ➕

    5) Inser new relational connection

    6) Provide resource name

    7) Click next

    8) Click on SAP and you can see the rest in the attached screenshot

    Let me know, whetehr you are looking  for this.

    Regards

    Arijit


    Untitled.jpg (114.5 kB)
    Add comment
    10|10000 characters needed characters exceeded

  • May 08, 2012 at 03:21 PM

    I was answering this question recently for someone, and here was some guidance i provided for the follow up:

    1. documents of interest:

    • Information Design Tool Guide: http://help.sap.com/businessobject/product_guides/boexir4/en/xi4_info_design_tool_en.pdf
    See “9.1.3 About multisource-enabled data foundations”

    • Data Federation Admin guide: http://help.sap.com/businessobject/product_guides/boexir4/en/xi4_dfat_guide_en.pdf
    See “4.5.1 List of connector properties for SAP NetWeaver BW data sources”

    • Data Access

    Guide: http://help.sap.com/businessobject/product_guides/boexir4/en/xi4_data_acs_en.pdf
    See 5.3 Creating JDBC connections

    2. a bunch of useful notes (& prerequisites):

    Note 1316106 - Data Federator: Configuration of RFC connection
    Note 1465871 - Minimal BW Authorizations for BO Data Federator
    Note 1460273 - NW BW 7.01/7.02: Missing error message in Data Federator
    Note 1426509 - Error "SAP NetWeaver BI cannot reach a callback server on this host (...) E_ERROR=99"
    Note 1604227 - Error Testing Relational connection to SAP BW system using the SAP Java Connector

    p.s. recommended BW version is 7.3 SP8 or 7.01 SP10

    3. As i remember it, the checklist broadly goes like this:

    a) Configure the Data Access folder and .SBO on BIPlatform (dataAccess\connectionServer\jdbc )

    • For single source, put .jar files under \dataAccess\connectionServer\drivers\java
    • for multi source, put .jar filder under  C:\Program Files\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\dataAccess\connectionServer\jdbc\drivers\datafederator\
    • specify the JAR filepaths in the 'ClassPath' of JDBC.SBO configuration file

    b) Split-out the Data Federation service into a dedicated APS (CMC > Servers)   -> see Note 1694041

    c) Configure the Data Federation service "query server" APS  (Server > Parameters)

    d) Configure the RFC destination (gateway host and gateway service ) in BW

    4. Re: JDBC configuration (step 3a):

    There are 2 ways to configure the JDBC driver: SBO or extensions
    - SBO: modify the CLASSPATH to the folder containing the driver files
    - Extensions: copy the drivers to one of the extensions folders configured in the SBO file
    - SBO takes precedence over Extension

    Regards,

    H

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 23, 2013 at 06:54 PM

    This was my problem, thank you!

    Add comment
    10|10000 characters needed characters exceeded