SAP BusinessObjects Designer (File) - Export - 7.1

Talend Data Catalog Bridges

author
Talend Documentation Team
EnrichVersion
7.1
EnrichProdName
Talend Big Data Platform
Talend Data Fabric
Talend Data Management Platform
Talend Data Services Platform
Talend MDM Platform
Talend Real-Time Big Data Platform
EnrichPlatform
Talend Data Catalog

Bridge Requirements

This bridge:
  • is only supported on Microsoft Windows.

  • requires the tool to be installed to access its SDK.

Bridge Specifications

Vendor SAP
Tool Name BusinessObjects (BO) Designer
Tool Version 6.x to 14.x
Tool Web Site http://www.sap.com/solutions/sapbusinessobjects/large/intelligenceplatform/
Supported Methodology [Business Intelligence] BI Design (RDBMS Source, Dimensional Target, Transformation Lineage, Expression Conversion), Graphical Layout via COM API on Universe (.UNV) File

Export tool: SAP BusinessObjects (BO) Designer 6.x to 14.x (http://www.sap.com/solutions/sapbusinessobjects/large/intelligenceplatform/)
Export interface: [Business Intelligence] BI Design (RDBMS Source, Dimensional Target, Transformation Lineage, Expression Conversion), Graphical Layout via COM API on Universe (.UNV) File to SAP BusinessObjects Designer (File) Export bridge: 'BoDesignerUnv' 10.1.0

This bridge relies on the Business Objects Designer OLE/COM API in order to export metadata to a Universe. Therefore, SAP Business Objects Universe Designer must be properly installed on the computer executing this bridge.

If unsure whether Designer is installed properly, be sure to check the following:
- Designer must be executable as a windows application on the machine which the bridge is running on. It generally is installed as part of the BO "desktop" tools.
- for the API to work, Designer must be executable as a COM/ActiveX component, i.e., the Designer COM/ActiveX component must be properly registered. You may check that a key exists in the windows registry in HKEY_CLASSES_ROOT\Designer.Application.

Also, at bridge runtime be sure that you have:
- valid login access to a BO repository server (the bridge must login to the BO platform)
- a valid database connection to the data warehouse for the model you want to convert.

Additional notes:
- The database connection is only necessary if you wish to change the database schema (tables). The connection is not required if you simply wish to update descriptions, for example.
- For BO 5.x, 6.x, 11.5, 12.x, 14.x there is the option of connecting to the server in standalone (no CMS) mode, if the bridge is running on the server.
- For BO 11.0 there is no standalone mode and you must have a valid login.


FREQUENTLY ASKED QUESTIONS

Q: What username and password should I supply into the BO login window?
A: If your company is using a network installation of Business Objects with a BO Repository managing users and access rights, please provide a BO username and password, the same way you would open the universe with BO Designer. If you are not sure about which username and password to use, you should contact your company BO system administrator (supervisor).

Q: The bridge fails to complete for an unknown reason, what can I do ?
A: Please try to run the bridge again with parameter 'Execution mode' set to 'Interactive'. The application may display an error in a pop-up window.

Q: How should I understand the warning message: The Connection 'DB' is not working?
A: This indicates that the database connection specified for the universe is not working. Please check the universe connection is working properly in Designer. The bridge uses the database connection to insert tables, columns and joins into the universe. Read the description of the bridge connection parameter for more details.

Q: Can this bridge run from an application server as a Windows service?
A: No, BO Designer is a desktop application, running the Designer COM api and this bridge as a service is not supported. Please make sure that if running from a remote bridge server, it is configured to run as a regular desktop application, not as a service.


KNOWN LIMITATIONS

- The names of classes and objects in BO Designer are limited to 35 characters. Consequently, names may be truncated and/or suffixed by numbers in the generated BO universe to address this limitation.

- BO Designer allows one to organize objects in a tree of classes. However, the namespace of classes is global, all classes must be uniquely named within the entire universe, rather than within a parent class. Consequently, names of classes may be truncated and/or suffixed by numbers in the generated BO universe to address this limitation.

- All BI design tools have limited dimensional modeling capabilities based on the underlying technology. For example, BO Designer supports joins at the physical data layer, but does not support joins at the logical or business layer. Consequently, some aspects of the original dimensional model may be re-engineered or lost during conversion.


Bridge Parameters

Parameter Name Description Type Values Default Scope
System Enter here the name of the Business Objects repository to login to.

- For Business Objects version 11.x and 12.x (XI), 14.x (XI R4) it is the name of the Central Management Server. This server will be used to login, by default on port 6400. For example: localhost. If the CMS server is configured in a Cluster environment, the cluster name may be specified with the following syntax: cms:port@cluster. For example: localhost:6400@MYCLUSTER

- For Business Objects version 5.x and 6.x, it is the name of the repository defined by the Supervisor application, for example: bomain. If this parameter is empty, Designer will perform an Offline login. A standalone installation of Business Objects does not require you to login.
STRING      
Authentication mode Select the login authentication mode to be performed.

This parameter is applicable to version 11.0 and later versions. Versions 5.x and 6.x do not have such mode.

'Enterprise' - Business Objects Enterprise login.
'LDAP' - Login using an LDAP server.
'Windows AD' - Login using a Windows Active Directory server.
'Windows NT' - Login using a Windows NT domain server.
'Standalone' - Standalone login (no CMS).

The default authentication mode is 'Enterprise'.
ENUMERATED
Enterprise
LDAP
Windows AD
Windows NT
Standalone
Enterprise  
User name A repository installation of Business Objects (BO) requires the user to identify himself/herself using a login. A standalone installation of BO does not require such identification. For example: supervisor

If you omit the username or password, a BO Login dialog box will be displayed, in which you should enter your usual BO login username and password.

In order to avoid Designer to prompt the Login dialog box when running this bridge remotely on a server, you should fill this option value.
STRING      
Password A repository installation of Business Objects (BO) requires the user to identify himself/herself using a login. A standalone installation of BO does not require such identification.

If you omit the username or password, a BO Login dialog box will be displayed, in which you should enter your usual BO login user name and password.

In order to avoid Designer to prompt the Login dialog box when running this bridge remotely on a server, you should fill this parameter value.
PASSWORD      
File Specify here the path to the universe file. FILE *.unv   Mandatory
Data model (Table/Join) algorithm Specify whether Tables and Joins should be exported to the universe.

'Unchanged' - The universe's Tables and Joins are left unchanged.
'Create all and Refresh from database' - Add to the universe the new Tables and Joins defined in the source model and refresh existing tables against the database connection (default).
'Recreate all' - Remove all existing Tables, Joins and Contexts from the universe, and replace them with new ones defined in the source model.
ENUMERATED
Unchanged
Create all and Refresh from database
Recreate all
Create all and Refresh from database  
Data model connection type Specify the Connection type as it was defined in Business Objects Designer.
The bridge needs to know the BO Connection name to create new Tables and Joins in the universe.

Note that the list of connections available at runtime depends on the authentication mode you use to login in Designer.
If you login as 'Enterprise' authentication mode (against a BO CMS repository), you should define and use a connection of 'Secured' type.
If you login as 'Standalone' authentication mode (no BO CMS repository involved), you should define and use a connection of 'Shared' type.
In general, connections of 'Personal' type are not recommended, they usually do not work via the COM automation API.

'Personal' - Personal connections restrict data access to the universe creator and the computer on which it was created. They are stored in the PDAC.LSI file located in the LSI folder in the Business Objects installation path, for example: C:\Program Files\Business Objects\BusinessObjects Enterprise 12\win32_x86\pdac.lsi .
'Shared' - Shared connections allow data access to all users. They are stored in the SDAC.LSI file located in the LSI folder in the Business Objects installation path, for example: C:\Program Files\Business Objects\BusinessObjects Enterprise 12\win32_x86\sdac.lsi .
'Secured' - Secured connections centralize and control access to data. It is the safest type of connection, and should used be to protect access to sensitive data. They are stored in the BusinessObjects repository. You must use secured connections if you want to distribute universes through the CMS. (default).
ENUMERATED
Personal
Shared
Secured
Secured  
Data model connection to RDBMS Specify the Connection name as it was defined in Business Objects Designer. The bridge needs to know the BO Connection name to create new Tables and Joins in the universe. This is a mandatory parameter.
The connection is necessary when creating a new universe file. When updating an existing universe file, this parameter is not used, the connection of the universe is not changed.
Note that the list of connections available at runtime depends on the authentication mode you use to login in Designer.
If you login as 'Enterprise' authentication mode (against a BO CMS repository), you should define and use a connection of 'Secured' type.
If you login as 'Standalone' authentication mode (no BO CMS repository involved), you should define and use a connection of 'Shared' type.
In general, connections of 'Personal' type are not recommended, they usually do not work via the COM automation API.

When executing this bridge on a remote bridge server, the connection should be valid and working on the remote server.
Please note that if the bridge is running on a remote server, this bridge server should be configured to run as an application, not as a windows service.
BO Designer is a desktop application, running the Designer COM api and this bridge as a service is not supported.

When using a connection based on an ODBC data source, make sure the ODBC DSN is correctly defined on the machine running the bridge.

When using a 64 bits version of Windows with BO Designer which is a 32 bits application, use the 32 bits ODBC manager (C:\Windows\SysWOW64\odbcad32.exe) to define the DSN.
Do not use the 64 bits ODBC manager (C:\Windows\System32\odbcad32.exe) on a Windows 64 bits, as the BO Designer 32 bits application will not work with the DSN.
REPOSITORY_MODEL     Mandatory
Data model Outer Joins Most modeling and ETL tools only define the metadata of foreign keys and do not specify the type of SQL join (inner or outer) that should be defined in Business Intelligence tools.

This parameter controls the type of joins which are generated for each foreign key relationship.
'False' - Use only Inner joins for foreign key relationships (Default).
'True' - Use the foreign key relationship optionality (optional versus mandatory) to determine if an 'Inner' or 'Outer' join should be used.
BOOLEAN   False  
Dimensional modeling detection When using this bridge to convert a data model created in a data modeling or ETL tool and then forward engineer it to an OLAP/BI model, the dimensional role that has been specified for each table (fact, dimension, outrigger) is always used by the bridge to infer how those tables are converted into BI facts and dimensions.

This parameter controls how additional table's dimensional role (fact, dimension, outrigger) is to be detected, if the source model did not specify that table's dimensional role.

'Only as defined by source model' - Use the tables dimensional role if defined by the source model.

'Autodetect additional Facts and Dimensions' - Automatic detection of fact and dimension tables from the relational schema, based on foreign keys. This algorithm considers tables with only incoming foreign keys as fact tables. Tables with outgoing foreign keys are considered dimension tables or outrigger tables depending on the minimum distance (number of foreign key relationships) to a fact table. Tables with no foreign key relationships to any other tables are considered to be dimension tables.

'Manually specified additional Facts and Dimensions' - Manually specify the fact and dimension tables.
ENUMERATED
Only as defined by source model
Autodetect additional Facts and Dimensions
Manually specified additional Facts and Dimensions
Autodetect additional Facts and Dimensions  
Dimensional modeling detection Fact tables When using this bridge to convert a data model created in a data modeling or ETL tool then and forward engineer it to an OLAP/BI model, the dimensional role that has been specified for each table (fact, dimension, outrigger) is used by the bridge to infer how those tables are converted into BI facts and dimensions. Specify the list of fact tables of your model in this parameter, and the bridge will consider those tables as fact tables when generating dimensions and measures. For example: dbo.Fact1; Fact2.

This parameter is useful if the source tool does not support this notion of table dimensional role, and may be used to work around the limitations of the source tool.

The behavior of this parameter may be combined with the 'Dimensional modeling detection Dimension tables' parameter, so that some tables are handled as facts and the others as dimensions.
STRING      
Dimensional modeling detection Dimension tables When using this bridge to convert a data model created in a data modeling or ETL tool and then forward engineer it to an OLAP/BI model, the dimensional role that has been specified for each table (fact, dimension, outrigger) is used by the bridge to infer how those tables are converted into BI facts and dimensions. You may use this parameter to control whether the bridge should assume that all tables are dimensions.

'True' - The bridge assumes that all tables are dimensions
'False' - The bridge uses the dimensional role specified on each table, if any.

The parameter's default value is 'True'.
This parameter is useful if the source tool does not support this notion of table dimensional role, and may be used to work around the limitations of the source tool.

The behavior of this parameter may be combined with the 'Dimensional modeling detection Fact tables' parameter, so that some tables are handled as facts and the others as dimensions.
BOOLEAN   True  
Dimensional model layers Specify how many layers of Classes and Objects to manage in the universe.

'one' - only one layer of Classes and Objects referring to the database schema tables and columns is created.
'two' - one private layer of hidden Classes and Objects referring to the database schema tables and columns is created, and one public layer of Classes and Objects referring to the private layer Classes and Objects is created.

This technique involving two layers may be used to better support update of a universe, and also separate objects available to report builders from objects used for internal universe implementation.
ENUMERATED
one
two
one  
Dimensional model (Object/Class) algorithm Specify how the dimensions should be exported to Classes and Objects in the universe.

'Unchanged' - The universe's Classes and Objects are left unchanged.
'Create only' - Create new Classes and Objects, leave the existing ones unchanged.
'Update' - Update the existing Classes and Objects according to the selected update mode.

The default algorithm is 'Create only'.
ENUMERATED
Unchanged
Create only
Update
Create only  
Dimensional model update mode Specify how the dimensions should be exported to Classes and Objects in the universe.

'Create / Replace' - Create new Classes and Objects, replacing the existing ones with the same name.
'Replace all' - Delete all current Classes and Objects and replace them with new ones.
'Update Objects properties' - Update the properties of all current Objects based on matching and update criteria.

The default algorithm is 'Create / Replace'.
ENUMERATED
Create / Replace
Replace all
Update Objects properties
Create / Replace  
Dimensional model update matching criteria This parameter applies when 'Dimensional model (Object/Class) algorithm' is set to 'Update Objects properties'. In this mode, the existing universe Objects' properties are updated with new properties provided by the source model. This parameter controls which measures and dimensions are updated with new properties of objects defined in the source model.

'Strict column matching' - The universe Object is updated based on a strict matching of its expression. For example, only measures defined by a strict "measure=Table.Column" equality will get updated with properties of that column.
'Single column matching' - The universe Object is updated if its expression involves a single column. For example, measures defined by "measure=Sum(Table.Column)" or "measure=Table.Column/365" will get updated with properties of that column.
'Multiple column matching' - The universe Object is updated for each column involved in its expression. For example, a measure defined by "measure=Table.Column1-Table.Column2" is updated with properties of both Column1 and Column2. This matching criteria may be used to concatenate the description of each column involved in a measure expression.

The default algorithm is 'Strict column matching'.
ENUMERATED
Strict column matching
Single column matching
Multiple column matching
Strict column matching  
Dimensional model update object name This parameter applies when 'Dimensional model (Object/Class) algorithm' is set to 'Update Objects properties'. Once a universe Object has been matched with a column in the source model, its name may be replaced by the column business name defined in the source model.

'No change' - The universe Object name is kept unchanged.
'Update' - The universe Object name is replaced by the column business name.

The default algorithm is 'No change'.
ENUMERATED
No change
Update
No change  
Dimensional model update object type This parameter applies when 'Dimensional model (Object/Class) algorithm' is set to 'Update Objects properties'. Once a universe Object has been matched with a column in the source model, its type (measure vs dimension) may be replaced by the column dimensional role defined in the source model.

'No change' - The universe Object type is kept unchanged.
'Update' - The universe Object type is replaced by the column dimensional role.

The default algorithm is 'No change'.
ENUMERATED
No change
Update
No change  
Dimensional model update object description This parameter applies when 'Dimensional model (Object/Class) algorithm' is set to 'Update Objects properties'. Once a universe Object has been matched with column(s) in the source model, its description may be replaced by the column(s) description defined in the source model.

'No change' - The universe Object description is kept unchanged.
'Update' - The universe Object description is replaced by the column description.
'Append' - The universe Object description gets appended with the column(s) description, if they are different.

The default algorithm is 'No change'.
ENUMERATED
No change
Update
Append
No change  
Dimensional model update object datatype This parameter applies when 'Dimensional model (Object/Class) algorithm' is set to 'Update Objects properties'. Once a universe Object has been matched with a column in the source model, its datatype may be replaced by the column datatype defined in the source model.

'No change' - The universe Object datatype is kept unchanged.
'Update' - The universe Object datatype is replaced by the column datatype.

The default algorithm is 'No change'.
ENUMERATED
No change
Update
No change  
Dimensional model Hierarchies Specify if the OLAP hierarchies defined in the source tool should be exported.

'False' - Do not export hierarchies.
'True' - Export hierarchies (Default).
BOOLEAN   True  
Dimensional model naming conventions Specifies how to generate the names in the Universe:

'Unchanged' - Use the names as defined in the source tool.
'Convert to Upper Case' - Convert the names to upper case.
'Convert to Lower Case' - Convert the names to lower case.

The names are also truncated to 35 characters which is the maximum length allowed in Designer.
ENUMERATED
Unchanged
Convert to Upper Case
Convert to Lower Case
Unchanged  
Dimensional model fact join objects Indicates whether the bridge should generate a business layer objects for fact table columns involved in joins as defined in the original (physical) dimensional model. By default, the bridge assumes that fact table columns involved in joins should be represented at the physical layer only. E.g., a fact dimension should be only represented in the business layer with a Class/Folder and its measures. This parameter allows control over this behavior.

'False' - Do not generate business layer objects for fact columns involved in joins.
'True' - Generate business layer objects for fact table columns involved in joins.
BOOLEAN   False  
Verbosity This parameter controls the dimensional modeling forward engineering verbosity level.

'False' - Normal verbosity.
'True' - Additional information is printed in the log.
BOOLEAN   False  
Silent execution Specify here whether to execute in interactive or silent mode.

'Silent' - The application runs in silent mode, pop-up windows and message boxes are blocked. This mode does not require user intervention, but may cause execution termination with unknown error.

'Interactive' - The application runs in interactive mode, allowing pop-up windows and message boxes. This mode may require user intervention to acknowledge pop-up windows, and allows the user to resolve issues during execution.

The default execution mode is 'Silent'.
ENUMERATED
Silent
Interactive
Silent  
Export to repository After the universe has been generated, the universe may be automatically exported to the BusinessObjects repository. Specify here a valid location within the BusinessObjects repository where the universe will be exported.
For BusinessObjects XI, specify a universe folder path, for example: /

For BusinessObjects 5.x or 6.x, specify a universe domain name, for example: Universes

If this parameter is left empty, the generated universe file is NOT exported to the repository.
STRING      

 

Bridge Mapping

Meta Integration Repository (MIR)
Metamodel
(based on the OMG CWM standard)
"SAP BusinessObjects Designer (File)"
Metamodel
BoDesigner
Mapping Comments
     
AggregationRule Object In case a Measure has multiple AggregationRules, multiple Objects of measure qualification are created, one for each AggregationRule
Rule Select  
AliasClassifier AliasTable  
Name Name  
AliasFeature AliasColumn  
Name Name  
Association Join Equi-joins are created to represent the primary key foreign key integrity constraints between the tables of the model
AssociationRole Join Represent both ends (Table1 and Table2) of the join
Multiplicity Cardinality and OuterJoin  
AssociationRoleNameMap   Associates the columns of table1 to the column of table2.
Attribute Column  
Name Name  
PhysicalName Name  
BaseType Object Type BaseTypes are created to represent the columns and objects datatype
DataType   See datatype conversion array
CandidateKey Column The primary key property is set on the primary key columns
Class Table  
Name Name  
PhysicalName Name  
ClassDiagram Structure Pane The Structure pane is populated with tables and views defined in the model and available via the connection to the database
DatabaseSchema Owner Only used to identify the tables in owner-supported universes
DesignPackage   Classes and associations of all packages of the model are exported, if possible
Dimension Class  
Description Description  
Name Name  
UserDefined   The dimension is exported only if the dimension is userDefined
DimensionAttribute Object An object of qualification 'dimension' or 'detail'
Description Description  
Name Name  
DrillPath CustomHierarchy Custom Hierarchies are imported as MIRDrillPath because they can span multiple MIRDimension (Classes)
Name Name  
DrillPathLevelAssociation CustomHierarchy Element  
Name Name  
FeatureMap Object Used to export the traceability of dimensional features
Description Description  
Operation Select  
ForeignKey   A foreign key is created to represent the columns involved in the join
Generalization Join Equi-joins are created to represent the primary key foreign key integrity constraints between the tables of the model
GeneralizationRole Join Equi-joins are created to represent the primary key foreign key integrity constraints between the tables of the model
Hierarchy CustomHierarchy  
Name Name  
HierarchyLevelAssociation CustomHierarchy CustomHierarchy
Position   used to order the objects in the CustomHierarchy
Index   An index is created for each join foreign key and for each primary key
IndexMember   Used to create joins when associated with primary and foreign columns
JoinGroup Join Context  
Name name  
LevelAttribute Object used to carry the traceability of its DimensionAttribute
LevelKey CustomHierarchy member Object The attribute of the key is exported as a member Object
Measure Object An object of qualification 'measure'
DefaultAggregation Function  
Description Description  
Name Name  
Projection Table Display Graphical Information
X x  
Y y  
SQLViewAttribute Column View columns are managed as regular Table columns in the tool
Name Name  
PhysicalName Name  
SQLViewEntity Table Views are managed as regular Tables in the tool
Name Name  
PhysicalName Name  
StoreConnection Qualifier Only used to identify the tables in qualifier-supported universes
StoreModel Universe The Universe is built using the tables that are both defined in the model and available via the connection to the database
Comment Comments  
Description Description  
Name LongName  
PhysicalName Name name of the .UNV file (8 characters)
TypeValue Object List of Values  
Position   In the order returned by the Designer API.
Value Value