SAP BI Business Objects RESTful Web Services

Name: SAP BI Business Objects RESTful Web Services
Rating: 4.1 (89 reviews)

Interactively execute SAP BI BOBJ RESTful Web Services; Execute custom developed SDK programs

Created bySuresh T

Last updated 10/2019

English

What you'll learn

Run SAP BOBJ RESTful Web Services interactively
Execute custom developed SDK programs (free download) to extract SAP BOBJ metadata

Course content

4 sections • 12 lectures • 39m total length

Introduction1:51
Explore how to interactively execute SAP Business Objects RESTful web services and run SDK programs to extract metadata and save it to SQL Server, with setup instructions for local environments.
Acronyms1:40
Learn common SAP BI business objects acronyms, such as BOBJ, Webi, CMC, REST, and SDK, and see how RESTful web services automate navigation on BI Launch pad.
Technical Requirements1:08
Ensure BI Launch pad login, a BOBJ client (or Restlet/soap UI) compatible with the server, Java JRE 7+, a fresh SQL Server with JDBC enabled, and SQL query design experience.

Identify SAP BO RESTful Web Service URL2:03
Identify SAP BO RESTful web service URLs (ending with biprws) for BI Launch Pad and CMC by using server name, port, and BOE/BI or BOE/CMC paths, and test with logon/long.
Install Restlet and interactively execute RESTful login web service3:21
Install restlet or switch to Talend API Tester, log in to the BOBJ server with a restful post call, xml body, and logon token from LDAP, Windows AD, or SAP.

Get list of Users and User Groups6:09
Learn to use SAP BI business objects restful web services to fetch users and user groups via get, including sorting, filtering, paging, and token handling.
Get list of BO documents and Data Providers2:38
Learn to list BO documents and their data providers via a REST web service, using the documents endpoint, paging with offset and limit, and the data providers extension.
Get list of Universes and Connections2:26
Explore how to use SAP BI Business Objects restful web services to retrieve universes and connections, authenticate with a logon token, and paginate results using offsets and limits.

Create new SQL Server Tables and Review significant columns in each table8:08
Learn how to configure two custom SDK programs that invoke restful web services and Universe SDK, creating SQL Server tables from the DDL scripts. Review columns in D_FOLDER_INFO and D_DOC_METADATA_HEADER.
Execute custom developed RESTful SDK program2:42
Execute a custom RESTful SDK program by configuring bobj_service_config.properties (env_type, cmc_host_address, cmc_login_user, cmc_login_pswd, CMC auth type) and running run_batch_program.cmd with JAVA_HOME set to a Java JRE 7+.
Execute custom developed Universe SDK program2:46
Configure and execute a custom Universe SDK program by updating the client configuration, setting environment and CMC credentials, SMTP details, then run the batch script with Java and BOBJ tools.
Troubleshooting tips to execute SDK programs4:27
Master troubleshooting for SAP BI RESTful Web Services SDK programs through log analysis, CMC login and Windows AD issues, and connection checks via telnet.

Requirements

Interactively execute RESTful Web Services: Soap UI or Restlet (Chrome browser extension is available for free download)
SDK Programs: Java JRE 7 or later should be installed on Windows PC
SDK Programs: Security access to create new tables in MS SQL Server database (DBA could assist)
BOBJ Client Tools should be installed to run Universe SDK program (not required for RESTful SDK program)
SDK Programs: SQL knowledge to design and develop queries

Description

SAP BI BO RESTful Web Services and Universe SDK will help answer many questions and some of those questions are:

What reports could be impacted if a table has been deleted or a table column has been modified?

How many reports are dependent on a specific Excel file as a data source?

How many reports have been updated in the past, say, 4 weeks?

What reports have never been updated since they were initially created?

What reports are available in different folders with the same title?

Download the SDK programs attached to this course and configure them with your local SAP BO and SQL Server environment details to extract list of BO documents, data sources (Universes, Bex Queries, Excel) and BO connections. No source code changes are required to execute the SDK programs. Run queries on SQL Server tables to export relevant data.

Who this course is for:

SAP BOBJ developers/consultants
SAP BW functional/technical developers
SAP Basis

SAP BI Business Objects RESTful Web Services

What you'll learn

Explore related topics

Course content

Introduction3 lectures • 5min

Interactively run SAP BO RESTful Web Service2 lectures • 5min

Get list of Users, User Groups, Documents, Data Sources, Universes, Connections3 lectures • 11min

Review SQL Server Tables & execute RESTful SDK program and Universe SDK program4 lectures • 18min

Requirements

Description

Who this course is for: