multisource relational connection in IDT

[Former Member]

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

[Former Member · Accepted solution]

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

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

Let me know, whetehr you are looking  for this.

Regards

Arijit

[Henry_Banks · Accepted solution]

Correct answer

[marcelo_rodrigues2]

This was my problem, thank you!

[Henry_Banks]

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