BusinessObjects Data Services provides a graphical interface that allows you to easily create jobs that extract data from heterogeneous sources, transform that data to meet the business requirements of your organization, and load the data into a single location.
A transform enables you to control how datasets change in a data flow.
Real-time jobs “extract” data from the body of the real-time message received and from any secondary sources used in the job.
Data Services also allows you to create a database datastore using Memory as the Database type. Memory Datastores are designed to enhance the processing performance of data flows executing in real-time jobs.
Data Services includes the following standard components:
All lookup functions return one row for each row in the source. They differ in how they choose which of several matching rows to return.
If you want a universe to be accessible in offline mode, you must first ensure that the universe has been opened at least once in online mode and that it has been saved with the Save for All Users check box selected in the Save Universe As box.
To make Offline mode available:
Online Default mode of operation for Designer when you are working in an environment with a repository.
Offline Mode of operation for Designer when you are not connected to a repository.
• Only available if you have previously connected in online mode.
• In offline mode you can open universes that are stored on your local computer only if those universes have been opened previously in online mode.
These are packages that enhance the ability of Data Cleanse to accurately process various forms of global data by including language-specific reference data and parsing rules.
A hierarchy, which the Designer sets up when creating the universe, consists of dimension objects ranked from “less detailed” to “more detailed”. The objects that belong to hierarchies are the ones you can use to define the scope of analysis.
The Data Cleanse transform identifies and isolates specific parts of mixed data, and standardizes your data based on information stored in the parsing dictionary, business rules defined in the rule file, and expressions defined in the pattern file.
Directories provide information on addresses from postal authorities. Dictionary files are used to identify, parse, and standardize data such as names, titles, and firm data.
A file format is a set of properties describing the structure of a flat-file (ASCII). File formats describe the metadata structure. File format objects can describe files in:
There are three types of connections namely: – Secured, Shared, and Personal.
A secured connection is used to centralize and control access to sensitive or critical data. It is the safest type of connection for protecting access to data.
A shared connection is used to access common resources such as universes or documents. Several users can thus use it.
A personal connection is specific to one user and can be used only from the computer on which it was created.
The DataServices repository is a set of tables that holds user-created and predefined system objects, source and target metadata, and transformation rules. There are 3 types of repositories.
2. In Memory
The software provides the following types of caches that your data flow can use for all of the operations it contains:
Use in-memory cache when your data flow processes a small amount of data that fits in memory.
Use a pageable cache when your data flow processes a very large amount of data that does not fit in memory.
A strategy is a script that automatically extracts structural information from a database or flat file.