Data Federation Administration Tool (DFAT): What it is, How it works, When to use it
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
- 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
- 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
- Efficiency of the reporting database and its network speed
- Query complexity
- Memory size
- Disk speed
- CPU speed
- 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
1465871 – Minimal BW Authorizations for BO Data Federator .. You are running Business Objects Data Federator on top of SAP BW. You want to know the minimal set of authorization that is required for the user in the SAP BW system.