User manual BUSINESS OBJECTS DATA FEDERATOR

[. . . ] The data sources can be spread across a network, managed by different data management systems and administered under different areas of the organization. This tool differs in its architecture to ETL (Extract, Transform, Load) tools in that the data it manages is not replicated in another system but optimized in the form of virtual data tables. The virtual database is a collection of relational tables that are manipulated with SQL but do not hold stored data. Data Federator allows you to consolidate your various data sources into one coherent set of target tables. [. . . ] See Mapping values between a datasource table and a domain table on page 159. Deleting an installed datasource When you delete a datasource, verify the components in the following table. To delete a final datasource, see the procedure at Deleting a datasource on page 106. Component What to verify How to verify it Edit the relationships in the Datasource relationships and filters pane, and verify if any of the relationships reference the datasource table that you deleted. See Finding incomplete relationships on page 178. mappings Did you delete a datasource table that participates in a relationship to another datasource table? Data Federator User Guide 235 8 Managing changes Reinstalling a datasource Component What to verify How to verify it Look for the icon Do the mapping rules that indicates an invalid directly reference datasource columns that formula. See Mapping a datasource table to a target table on page 129. Does the constraint check find constraint violations because of changes to the mappings?If the mappings are affected, check that the constraints still pass. constraint checks lookup tables Edit the relationships in the Datasource relationships and filters pane, and verify if any of the relationships reference the datasource Do the lookup tables map that you deleted. a column from a You may need to add a datasource you deleted?different datasource, and a different lookup table, to complete the relationship. See Finding incomplete relationships on page 178. Reinstalling a datasource When you reinstall a datasource, verify the same components as when Modifying the schema of a final datasource on page 233. 236 Data Federator User Guide Managing changes Modifying a target 8 1. Copy a final datasource to a draft (see Editing a final datasource on page 100). Reinstall a source of data for the draft datasource (see The process of configuring a datasource of type "text file" on page 65 or Adding a generic JDBC datasource on page 84). Make the datasource final again (see Making your datasource final on page 99). Verify the components listed in the section Modifying the schema of a final datasource on page 233. Modifying a target To modify a target, see Adding a target table manually on page 44. When you modify a target, verify the following components. Component What to verify How to verify it You must consider what result a query will return when you run it on the new definitions of the keys. mappings Did you change the definitions of the primary Check if the new definition of your keys keys?yields a different result. See Mapping a datasource table to a target table on page 129. Data Federator User Guide 237 8 Managing changes Adding a mapping Component What to verify How to verify it Look for the icon Do the mapping formulas that indicates an invalid result in types that have formula. See Mapping a datasource table to a target table on page 129. Does the constraint check find constraint violations because of changes to the mappings?If the mappings are affected, check that the constraints still pass. constraint checks Adding a mapping To add a mapping, see Mapping a datasource table to a target table on page 129. When you add a mapping, verify the following components. Component What to verify How to verify it constraint checks Does the key constraint check find constraint Check that the key violations among the set constraints still pass. of mapping rules because of the new mapping? 238 Data Federator User Guide Managing changes Modifying a mapping 8 Modifying a mapping To modify a mapping, see Mapping a datasource table to a target table on page 129. When you modify a mapping, verify the following components. Component What to verify How to verify it constraint checks Does the constraint check find constraint violations among the set Check that the of mapping rules because constraints still pass. of changes to the mapping? Adding a constraint check To add a constraint check, see Defining constraints on a target table on page 194. [. . . ] It is possible to create a table with no name, but you cannot select it. Action Make sure the table has a name. Cannot find column names Data Federator cannot find column names Cause Do your column names have leading or trailing spaces?Data Federator allows blank characters in column names, but the spaces may be difficult to see on the screen. Action If your columns have leading or trailing spaces, type the spaces in the names when you use the Data Federator Designer interface. [. . . ]