Workflow For Creating a Project At Business Objects Data Federator
1) Log on to the Data Federator designer using the sysadmin or with the new account created for the Designer.
2) Once the Data Federator designer is launched, create a new project by clicking on the Project Tab present at the top of the window.
3) Click on the Add Project option and enter a name for your project in the new project window and click OK.
4) By clicking on the SAVE button at the Project Configuration, your project will be added to the list of Data Federator Project List.
5) Once is the Project is created the next step will be to add the Data Sources for your project .For adding a data source click on the Project Tab and select the Add data source option which will pop up a new data source dialog window.
6) Select your data source from the tree list along with the connection parameters and finally click on the gateway parameters which have been set as the default value.
7) Test your connection by clicking on the ‘Test the Connection’ button.
8) If you are connected to the Info cube then select the fact tables from your info cube by clicking on the Fact Table name icon and say ok.
9) Scrolling down, you can see all the tables associated to this fact table in the data source tables. The tables associated to the fact table are the dimensional and text tables. Select the required tables and click Save.
Note: - Whenever we create a new project or data source at Data Federator it is saved in a draft version indicating the the definition is incomplete, in order to use the data source which you have created you will be required to make it as final by clicking on the datasoruce name in the tree on the left and then clicking on the Make final button.
10) Finally deploy your project into Data Federator Query Server by clicking on the Deploy button in the project toolbar.
IMPORTANT POINTS TO BE REMMEMBERED
A) While creating a Data Federator project, import only the required tables for the target table mapping
B) Validate all the data sources before making them as ‘FINAL’
C) While creating a Target Table, Create/Import only the required columns for the target table.
D) In case of any changes to the source layer, ensure that the corresponding Lookup/Domain/Target Tables mapping are modified accordingly
E) Validate the Data Federator design using the Mapping Test Tool pane before being used by other interfaces like Universe Designer
F) Follow standard naming conventions – Project (PRJ_), Virtual/Target tables (TGT_), Data Source (DS_), Catalogue (generally the Project Name), Lookup Table (LKP_), Domain Table (DMN_), Mapping Rule (MAP_), Constraints (CON_).
G) Always validate the mapping prior to deployment of the project.
H) Keep track the versions of the project (Archive file) in local.
I) Complex calculations should be avoided at DF level.