SAP BusinessObjects Repository XI - Import - 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) Repository
Tool Version 11.x to 14.x
Tool Web Site http://www.sap.com/solutions/sapbusinessobjects/large/intelligenceplatform/bi/information-infrastructure/enterprise
Supported Methodology [Business Intelligence] Multi-Model, Metadata Repository, BI Design (RDBMS Source, Dimensional Target, Transformation Lineage, Expression Parsing), BI Report (Relational Source, Dimensional Source, Expression Parsing, Report Structure), Graphical Layout via Java API
Incremental Harvesting
Multi-Model Harvesting
Remote Repository Browsing for Model Selection
Data Profiling

BRIDGE INFORMATION
Import tool: SAP BusinessObjects (BO) Repository 11.x to 14.x (http://www.sap.com/solutions/sapbusinessobjects/large/intelligenceplatform/bi/information-infrastructure/enterprise)
Import interface: [Business Intelligence] Multi-Model, Metadata Repository, BI Design (RDBMS Source, Dimensional Target, Transformation Lineage, Expression Parsing), BI Report (Relational Source, Dimensional Source, Expression Parsing, Report Structure), Graphical Layout via Java API from SAP BusinessObjects Repository XI
Import bridge: 'BoRepository11' 10.1.0

BRIDGE DOCUMENTATION
This bridge requires SAP BusinessObjects SDKs and a specific Java JRE as explained below.

JAVA REQUIREMENTS
BusinessObjects supports Java 8 only and is not compatible with any version of OpenJDK which may be the default JRE.
The bridge will try to reuse the JRE bundled with the BusinessObjects Client software.
You may also use the Miscellaneous parameter to point to a Java environment supported by BusinessObjects.
UNX Universes based on jdbc connections are supported with a 64 bit JVM.
UNX Universes based on other types of connections (odbc, oledb, ...) are only supported if using a 32bit JVM.
You may specify the path to a 32 bit JVM in this option, in order to support UNX universes based on an odbc connection.

BUSINESS OBJECTS SDK REQUIREMENTS
The bridge relies on the SAP BusinessObjects Universe Designer OLE/COM API to import the Universe metadata. Therefore, SAP BusinessObjects Universe Designer must be properly installed on the machine executing this bridge.

The bridge relies on the SAP BusinessObjects Desktop Intelligence COM/OLE API to import the Report metadata. Therefore, SAP BusinessObjects Desktop Intelligence must be properly installed on the machine executing this bridge.

The bridge relies on the SAP BusinessObjects Web Intelligence SDK to import Report metadata.
For XI versions 4.0 SP6 and newer, the WebIntelligence import bridge uses the WebIntelligence RESTful Web Service SDK.
For XI versions 4.0 up to SP5, the WebIntelligence import bridge uses the deprecated WebIntelligence Report Engine (Rebean) SDK, which provides limited metadata.
For XI versions up to 3.x, the WebIntelligence import bridge uses the WebIntelligence Report Engine (Rebean) SDK.

The bridge relies on the Semantic Layer Java SDK to import Information Design Tool (IDT) universe metadata.
For XI versions 4.1 and newer, the Semantic Layer Java SDK is supported.
For XI versions 4.0 and older, the Semantic Layer Java SDK is not supported.

If unsure whether the Semantic Layer Java SDK is installed properly, be sure to check the following:
- BusinessObjects Information Design Tool can be started on the machine which the bridge runs on. It generally is installed as part of the BusinessObjects client tools.
- In Windows Control Panel > Programs > Programs and Features, you see 'SAP BusinessObjects BI platform 4.1 Client Tools'.
- In the BusinessObjects client tools installation directory, you see a folder 'SL SDK'. For example: C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\SL SDK

The required SL SDK is not installed by default. You need to install the SL SDK as an additional component to the Client Tools.
If the 'SL SDK' folder is not present in the client installation directory:
- click the button 'Uninstall/Change' on the 'SAP BusinessObjects BI platform 4.1 Client Tools' to run the installation wizard again,
- Select the Modify option and click Next twice.
- In the 'Select Features' screen, scroll down to Developer Components and check 'SAP BusinessObjects Semantic Layer Java SDK',
- Follow the remaining steps to install the Semantic Layer SDK resources on your machine. The 'SL SDK' folder should now be available.

There is a tool available from SAP BusinessObjects which can test for some connectivity issues. Go to Start -> All Programs -> Business Objects XI -> Diagnostic Tool. You must login with the same credentials as you use with the bridge. Then go to the menu Tests -> Run All Tests. You should see that all tests 'Pass'.

In addition, one may customize the configuration file used to control what tests are performed. It is located at C:\Program Files (x86)\Business Objects\common\4.0\java\lib\TestClasses.xml in the default SAP BusinessObjects client installation.

If any of these tests fail, please contact the local SAP BusinessObjects Administrator to resolve these issues. Please refer to Chapter 5, 'Working with Firewalls' in the SAP BusinessObjects Administration Guide.

At runtime, the bridge requires the following SAP BusinessObjects 'servers' to be started and enabled on the SAP BusinessObjects environment:
- for WebIntelligence Report Engine (Rebean) SDK: WebIntelligenceProcessingServer
- for WebIntelligence RESTful Web Service SDK: WebApplicationContainerServer (applicable for version XI R4.x)

Use the Central Management Console web application to check:
- Under the 'Servers' menu: the above servers are available and running correctly
- Under the 'Applications' menu: the 'RESTful Web Service' is available, it may not be installed by default.

The BusinessObjects BI Platform SDK is based on CORBA technology.
When connecting to a remote server, the CORBA networking layer performs a bi-directional resolution of the server name/address.
Therefore, it is necessary to ensure that the specified server name/address can be resolved in the client environment.
The name resolution is usually successful when the client and server are part of the same enterprise network.
However when connecting from a client network to a server in a different network (for example Amazon AWS),
it may be necessary to configure an entry in the local host file (C:\Windows\System32\drivers\etc\hosts) like so:
1.2.3.4 servername

FREQUENTLY ASKED QUESTIONS
Q: What username and password should I supply as BO login?
A: Please provide a valid BO username and password, the same way you would login with Designer or Desktop Intelligence.
For example: Administrator
If you are not sure about which username and password to use, you should contact your BO system administrator.
For version 11.x and 12.x (XI), the user should be a member of BusinessObjects groups:
- 'Universe Designer Users' to be able to open universes.
- 'Administrators' to be able to access favorite folders.

Q: The bridge fails to import a UNV universe for an unknown reasons, what can I do ?
A: Please try running the BusinessObjects Designer bridge to import the UNV universe, and set the parameter 'Execution mode' to 'Interactive'.
The application may display an error in a popup window.

Q: Why does the Crystal Report Application Server (RAS) fail to start?
A: Since version 12.0 (XI 3.0), one needs to configure the RAS manually, as follows:
- Using the CMS Administration web console, enable the Guest account.
As of version XI 3.0, the Guest account is disabled by default.
- Using the CMS Administration web console, configure the RAS startup command line with a parameter -ipport to specify a port number that you know to be free. For example, you can set the ipport switch to specify the default port 1566 with -ipport "1566". For further details, see the BusinessObjects Enterprise Administrator's Guide.
For older versions 11.x, similar recommendations still apply, the Guest account must be enabled, and the RAS server must be running and enabled. Use the Central Configuration Manager to check the status of the Report Application Server (RAS).

Q: What report file formats does this bridge support?
A: This bridge can read the report formats supported by SAP BusinessObjects Desktop Intelligence:
- BusinessObjects documents (*.rep)
- BusinessObjects document templates (*.ret)
- BusinessQuery Files (*.bqy)
- WebIntelligence 2.x documents (*.wqy)
- Crystal reports (*.rpt) since version 11

Q: What report file formats are not supported?
A: BusinessObjects Desktop Intelligence and this bridge do not support:
- WebIntelligence 6.x documents (*.wid)
- Crystal reports (*.rpt) prior to version 11
- Crystal OLAP Analysis reports (*.car)

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.

Q: What are the recommended firewall settings for running this bridge?
A: This bridge relies on the BusinessObjects client components to be able to communicate reliably with the BO server.
Designer, DesktopIntelligence, WebIntelligence and Crystal must be able to logon with the CMS, download and open universes and documents. If your firewall is not properly configured, the bridge may hang indefinitely, or fail with no clear explanation. For detailed firewall settings, please ask your system administrator and refer to the BusinessObjects documentation. Alternatively, you can disable the firewall and check the bridge runs correctly without it.

Q: Why some universe dependent report documents appear missing?
A: The subsetting by universe feature relies on the BO Repository metadata cache of dependency between universes and report documents, and therefore works well on production environments where all reports are actively used. However, in the context of BO Repositories in development and test environments, some universes and/or report documents may have been redesigned or moved leaving inaccurate dependency information in the BO Repository cache. In such case, all dependent report documents of a given universe may not be detected. The BO repository cache can be refreshed by editing such document, refreshing the queries, and saving it back into the BO server.
In order to verify that a particular document is properly linked to its universes in the BO server cache, you can:
- Start the CMC administration web console (not InfoView)
- Navigate through the public folders and find the document you are interested in
- Display the properties of the document
- The tab labeled 'Universe' (in versions 11.x) or 'Report Universes' (in versions 12.x) shows the universe dependencies

Q: What are the BO requirements to properly use the BO bridges?
A: Ensure all the following recommendations are met:
1. The bridge should be installed on a machine with the SAP BusinessObjects client installation only. It should not be installed on a machine which has SAP BusinessObjects server.
2. The bridge should be run as a desktop application, not as a Windows service.
3. Do not use remote access technologies such as Microsoft Netmeeting, SharedView or Office LiveMeeting, as COM-based remote access technologies have been known to interfere with the SAP BusinessObjects API's and thus bridge function.
4. Ensure that there are no firewall restrictions for access to the SAP BusinessObjects API and server. If the bridge is failing to connect properly, disable the firewall temporarily to ensure that it is not the cause of the failure.
5. Always use the SAP BusinessObjects user 'Administrator' when using this bridge, as many of the API calls that the bridge uses provide complete information only if one connects as the user 'Administrator'.
6. Be sure that the latest SAP BusinessObjects service packs are installed, and that they are installed consistently on the server and client machines.
7. Clean up the temporary universe download directory, as some stale or locked files can prevent importing universes. Delete all temporary files from this directory. This directory path is configured in Designer: Tools menu -> Options -> Save -> Default Universe Folder. This directory path may be saved in the registry in: HKEY_LOCAL_MACHINE\SOFTWARE\Business Objects\Suite XXXX\default\Shared\General\Directories\Universes
8. If there are any 'designer.exe' processes running on the system before running the bridge, terminate them using the task manager, as they could interfere with proper COM apis execution.

Q: Why are some universes imported which are not in the folders specified for the import?
A: The bridge tries to harvest a self-contained set of BO objects. If the bridge parameter 'Add dependent objects = True' the bridge will import all reports dependent on the specified universes and in case these reports depend on any other universes the bridge should import them as well, in order to be sure these reports are fully defined.

SUPPORT
Q: How do I provide metadata to the support team to reproduce an issue?
A: Provide the following files:
- For BusinessObjects 6.x, save the universe(s) as UNV file(s) and document(s) as REP file(s) with check the check-box 'Save for all users' enabled.

- For BusinessObjects 11.x and 12.x (XI), it is no longer possible to exchange metadata as files between different Central Management Server repositories.
To exchange universe(s) and document(s) between two CMS repositories, create a Business Intelligence Archive file (*.BIAR) using the BusinessObjects Import Wizard utility (ImportWiz.exe) and include the universe(s) and document(s) of interest in it.

- for BusinessObjects 14.x (XI R4): using the Lifecycle Management Console, create a promotion job that has the required Infoobjects in it. Export the job as BIAR file. Below is the outline (for more details please see "Lifecycle management console for SAP BusinessObjects Business Intelligence platform 4.0 User Guide"):
1. Log into the lifecycle management console application. By default, you will be taken to the "Promotion Jobs" page.
2. Select New Job.
3. Enter the name, description, and keywords for the job in the appropriate fields.
4. In the "Save Job in" field, browse and select the repository folder where you want to save the job.
5. From the Source drop-down list, select the current system.
If the name of the current system is not listed, select the Login to a new CMS option. A new window is launched. Enter the name of the current system along with the username and password.
6. In the Destination drop-down list, select "Output to LCMBIAR File".
7. Click Create. A new job is created and stored in the CMS repository of the current system.
8. Add Infoobjects to the Job (including universes and connections of interest). You can also use the Manage Dependencies option to include the dependents of the selected Infoobjects.
9. Once done adding Infoobjects to the job, click Promote. The "Promote" window appears.
10.Click Export. You can choose to save the resulting BIAR file to a File System or an FTP location.
Send the BIAR file to the support team.

Q: Is there a way to test that the WebIntelligence RESTful Web Service is working correctly?
A: It is possible to test the BusinessObjects 14.x (XI R4) WebIntelligence RESTful Web Service by connecting to the following URLs:
Login api: http://boserver:6405/biprws/logon/long
InfoStore api: http://boserver:6405/biprws/infostore/12345

The developer documentation is available at:
http://help.sap.com/businessobject/product_guides/boexir4/en/xi4sp9_webi_restful_ws_en.pdf
The Curl command line utility allows automating such api calls as command line scripts:
http://curl.haxx.se/


Bridge Parameters

Parameter Name Description Type Values Default Scope
Version Select here the version of BusinessObjects you want to connect to.
This software version must be installed on the computer that runs this bridge.
Using 'Auto detect', the bridge will try to recognize the version of the BusinessObjects client software installed locally.
Note that applying different SAP BusinessObjects Service Packs may or may not change the version number.

For all 14.2 (XI R4.2) Service Packs, select 14.2 as version.

For all 14.1 (XI R4.1) Service Packs, select 14.1 as version.

For 14.0 (XI R4.0) Service Pack 6 and above, select 14.0.6 as version.

For 14.0 (XI R4.0) up to Service Pack 5, select 14.0 as version.

For all 12.1 (XI R3.1) Service Packs, select 12.1 as version or 'Auto detect'.

For all 11.5 (XI R2) Service Packs, select 11.5 as version or 'Auto detect'.

For all 11.0 (XI) Service Packs, select 11.0 as version or 'Auto detect'.
ENUMERATED
Auto detect
14.2 (XI R4.2)
14.1 (XI R4.1)
14.0.6 (XI R4.0 SP6 and above)
14.0 (XI R4.0 up to SP5)
12.1 (XI R3.1)
12.0 (XI R3)
11.5 (XI R2)
11.0 (XI)
Auto detect  
System Enter here the name of the BusinessObjects repository to login to.

For BusinessObjects version 11.x and 12.x (XI), 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 can be specified with the following syntax: cms:port@cluster. For example: localhost:6400@MYCLUSTER
STRING   localhost Mandatory
Authentication mode Select the login authentication mode to be performed.

'Enterprise' - BusinessObjects Enterprise login.
'LDAP' - Login using an LDAP server.
'Windows AD' - Login using a Windows Active Directory server.

The default authentication mode is 'Enterprise'.

Note: Windows AD authentication can be configured using Kerberos configuration files.
Update the file $MetaIntegration/conf/conf.properties to specify the Java virtual machine parameters:
M_JAVA_OPTIONS=-Djava.security.auth.login.config=C:\Windows\bscLogin.conf -Djava.security.krb5.conf=C:\Windows\krb5.ini

For details, see SAP Note 1621106:
http://service.sap.com/sap/support/notes/1621106
ENUMERATED
Enterprise
LDAP
Windows AD
Enterprise  
User name A repository installation of BusinessObjects (BO) requires the user to identify himself/herself using a login.
For example: Administrator (versions 11.x and 12.x)
If you are not sure about which username and password to use, you should contact your company BO system administrator (supervisor).
For version 11.x and 12.x (XI), the user should be a member of BusinessObjects groups:
- 'Universe Designer Users' to be able to open universes.
- 'Administrators' to be able to access favorite folders.
STRING   Administrator Mandatory
Password A repository installation of BusinessObjects (BO) requires the user to identify himself/herself using a login. Enter the user password here. PASSWORD      
Repository browsing mode Specifies what will be retrieved when browsing for available objects in the BusinessObjects repository.
'Universes only' - The tree of Universes and Folders is retrieved. No documents are retrieved.
'Connections only' - The list of Connections is retrieved.
'All' - The tree of Universes, Folders and Documents is retrieved. This mode requires more time to complete on large repositories. This is the default.
ENUMERATED
Universes only
Connections only
All
All  
Repository subset This option is used to access objects stored in a remote BusinessObjects Repository.

You can specify here multiple IDs of universes, reports and/or folders, to be retrieved, separated by semicolon (;) character.
REPOSITORY_SUBSET      
Incremental import Specifies whether to import only the changes made in the source or to re-import everything (as specified in other parameters).

True - import only the changes made in the source.
False - import everything (as specified in other parameters).

An internal cache is maintained for each metadata source, which contains previously imported models. If this is the first import or if the internal cache has been deleted or corrupted, the bridge will behave as if this parameter is set to 'False'.
BOOLEAN
False
True
True  
Add dependent objects This parameter allows selection of documents that depend on the selected universes.

'True' - The documents dependent on selected universes are imported. (default)
'False' - The documents dependent on selected universes are not imported.

WARNING: This feature relies on the BO Repository metadata cache of dependency between universes and report documents, and therefore works well on production environments where all reports are actively used. However, in the context of BO Repositories in development and test environments, some universes and/or report documents may have been redesigned or moved leaving inaccurate dependency information in the BO Repository cache. In such case, all dependent report documents of a given universe may not be detected. The BO repository cache can be refreshed by loading such modified or moved report documents and refreshing the queries.
BOOLEAN
False
True
True  
Add specific objects This parameter allows selection of additional objects.

'Universe independent Documents' - The documents that do not depend on any universe are imported.
ENUMERATED
None
Universe independent Documents
None  
Crystal CORBA port Specifies the client port number on which the Crystal SDK will communicate with the report application server (RAS). If no port is specified, the RAS server will randomly select a port for each execution. If specified, the RAS server will use that port to send metadata to the local client computer. Please make sure that the local Windows firewall is disabled, or allows receiving communication on this port. If using an enterprise firewall, configure it to allow communication from the RAS server to the client computer on this port. If a firewall is blocking communication, the client Crystal SDK will wait for metadata indefinitely. NUMERIC      
Class representation This parameter controls how the tree structure of Classes and subClasses should be imported. The bridge will import each Class containing Objects as a Dimension (as defined by the CWM OLAP standard). In addition, Classes and subClasses can also be imported as a tree of Packages (as defined by the CWM and UML standards).

'As a flat structure' - No Packages are created (default).
'As a simplified tree structure' - A Package is created for each Class with subClasses.
'As a full tree structure' - A Package is created for each Class.
ENUMERATED
As a flat structure
As a simplified tree structure
As a full tree structure
As a flat structure  
Import joins Specify whether joins and contexts should be imported.

'True' - The joins and contexts are imported. (Default)
'False' - The joins and contexts are not imported.
BOOLEAN
False
True
True  
Import hierarchies Specify whether hierarchies should be imported.

'True' - The hierarchies are imported. (Default)
'False' - The hierarchies are not imported.
BOOLEAN
False
True
True  
Multiple threads Number of worker threads to harvest metadata asynchronously.
Leave the parameter blank to have the bridge compute the value, between 1 and 6, based on JVM architecture and number of available CPU cores.
Specify a numeric value greater or equal to 1 to provide the actual number of threads.
If the value specified is invalid, a warning will be issued and 1 will be used instead.
If you experience out of memory conditions when harvesting metadata asynchronously, experiment with smaller numbers.
If your machine has a lot of available memory (e.g. 10 Gb or more), you can try larger numbers when harvesting many documents at once.
Note that setting the number too high can actually decrease the performance due to resource contention.
NUMERIC      
Miscellaneous Specify the following miscellaneous options:
-jre "C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\win32_x86\jre8\bin\javaw.exe"

-jre:
You may need to specify a Java environment supported by BusinessObjects, if the default JVM is not compatible (OpenJDK 11 instead of Oracle JVM 8) or if the default JVM is 64 bit but the universes are using ODBC connections, which require a 32 bit JVM.
UNX Universes based on jdbc connections are supported with a 64 bit JVM.
UNX Universes based on other types of connections (odbc, oledb, ...) are only supported if using a 32bit JVM.
You may specify the path to a 32 bit JVM in this option, in order to support UNX universes based on an odbc connection.

-m the maximum Java memory size whole number (e.g. -m 1G or -m 1024M ).
STRING      

 

Bridge Mapping

Meta Integration Repository (MIR)
Metamodel
(based on the OMG CWM standard)
"SAP BusinessObjects Repository XI"
Metamodel
BoRepository
Mapping Comments
     
ClassifierMap   The Mapping Models use many ClassifierMaps to connect QuerySubjects and Filters defined in FM models with QuerySubjects and Filters used in reports
Connection   Used to store stitching mappings between report models and universe models
DirectoryStructureModel Repository  
Name name  
FeatureMap   The Mapping Models use many ClassifierMaps to connect Objects and Filters defined in Universe models with Objects and Filters used in documents
Folder Folder, Category  
Description description  
Name name  
MappingVersion   Used to store stitching mappings between report models and universe models
ModelVersion Universe, Document  
MultiModelVersion Repository  
StoreContent Universe, Document  
Name name  
NativeId path or id  
StoreModel Universe, Desktop Intelligence Document, WebIntelligence Document All runiverses and documents are imported using the Designer, Reporter and WebIntelligence import bridges. See the respective bridges specification for details on metadata mapping of each tool.
Name name