Purpose

sonet_kebede · ‎05-22-2014

The purpose of this WIKI page is to demonstrate an overview of the Data Federation Administration Tool.

What is the purpose of the Data Federation Administration Tool?
Workflow: Information Design Tool (IDT), Data Federation Administration Tool (DFAT), Example: SAP BW
Factors to be considered for performance
Trace
Reference SAP Knowledge bases & Notes

What is the purpose of the Data Federation Administration Tool?

To administer or tune the data federation service
Integrated in the SAP BusinessObjects Business Intelligence (BI) platform
The data federation service enables multi-source universes by distributing queries across disparate data sources and lets you federate
data through a single data foundation.
The Data Federation Administration Tool lets you optimize data federation queries and fine-tune the data federation query engine for the
best possible performance.
With the Data Federation Administration Tool, you can browse and manage connectors, browse data sources and run queries against them,
manage statistics, and view the lists of past queries and running queries.

Purpose of the Data Federation Administration Tool

Test your SQL queries.
Visualize optimization plans, which detail how federated queries are distributed to each source.
Compute statistics and set system parameters to fine-tune the data federation services and get the best possible performance.
Manage properties to control how queries are executed in each data source at the connector level.
Monitor running SQL queries.
Browse the history of executed queries.

Workflow: Information Design Tool (IDT), Data Federation Administration Tool (DFAT), Example: SAP BW

Information design tool allows us to create a local projects and resources (connections, data foundations, business layers).

Create a local project…File > New > Project.
Define the connections. Connections for multisource must be secured
Create the data foundation…New > Data Foundation….Create a multisource-enabled data foundation.
Create the business layer….The business layer must be based on a multisource-enabled data foundation.

You also use the new universe wizard to create your first universe in 5 minutes.

Data Federation Administration Tool

Configuring connectors to sources of data
Start the data federation administration tool.
Click the Connector Configuration tab.
Right-click a connector in the tree list, then click Create configuration.
In the Configuration Properties tab, double-click a property to edit it, change the value, then click the Save data icon to save your changes.
Click the General information to view the settings, or capabilities of the connector
List of specific connector properties for each database can be found in the Data Federation Administration Tool Guide

SAP BW

Check the BW Authorizations for BO Data Federator. SAP BW authorizations for SAP BusinessObjects data federator: KB 1465871 - Minimal SAP BW authorizations for SAP BusinessObjects data federator
SAP NetWeaver BW uses a callback ID in order to contact the data federation service.
Configure RFC destination for SAP JAVA Connector (SAP JCO) connection. If this property is not defined, Data Federator will automatically create an RFC destination. This RFC destination will be created using a program ID identical to the name of the RFC destination.
1638647 - How to manually configure RFC destinationfor JCO connection

We need to set the following properties

programIDMapping: Name of I_RFC_DESTINATION. MySia.AdaptiveProcessingServer=DF_JCO_MYHOST
gatewayHostname: type in the FQDN of the SAP BW server you are connecting to or IP address.
gatewayServiceName: In the gatewayServiceName, enter the gateway name

Factors to be considered for performance

Trace

The data federation service is hosted by an adaptive processing server on the SAP BusinessObjects BI platform. You can find the logs
for your data federation service in the adaptive processing server that is hosting the service.
JCO / RFC trace: The higher-level directory <Data Federator Installation Directory>\LeSelect\ contains the JCO trace called dev_jco_rfc.trc. This file provides information about errors in the communication from the data federator to the SAP BW server.
To see the dev_jco_rfc.trc, you must enable the trace from the adaptive processing server. 1717718 - dev_jco_rfc.trc file not getting generated