如何使用java从sap获取宇宙、类、对象、报告名称、报告字段 [英] How to get universe,classes,objects,report names, report fields from sap using java

问题描述

在此之后，我可以通过 java (SDK) 连接 SAP BO 服务器，因为我不知道查询以获取所有 BO 元数据(宇宙名称、类、对象、报告名称、报告变量，如 oracle)，因为我需要存储所有 bo 元数据从 BO 服务器到我的本地数据库(mysql).我是 SAP BO 的新手.我对此感到震惊.请就此提出任何建议.所有线索都是可观的.

i am able to connect SAP BO server via java (SDK) after this i don't know queries to get all BO Metadata (universe name,classes,objects,report names,report variables separately like oracle) as i need store all bo metadata into my local db(mysql) from BO server. I am new to SAP BO. i was struck on this. please suggest any one on this.All leads are appreciable.

public static void main(String[] args) throws Exception {

      IEnterpriseSession enterpriseSession = null;
      try {
         // Establish connection
         System.out.println("Connecting...");
         IEnterpriseSession enterpriseSession = sessionMgr.logon(user, pass, host, auth);
         IInfoStore infoStore =(IInfoStore)enterpriseSession.getService("InfoStore");
}

我的预期输出将是如何以表格形式检索所有 BO 元数据(宇宙名称、类、对象、报告名称、报告列)谎言 sql 表

my expected output would be that how retrieve all BO Metadata(universe name, classes,objects,report names,report columns) in tabular form lie sql tables

推荐答案

从 BO 服务器检索元数据的最简单方法是使用 CMS 查询.您可以通过 REST API 使用 CMS 查询.

Easiest way to retrieve metadata from the BO Server is to use CMS queries. You can use CMS queries with the REST API.

从您的 cms 中的 Universe 检索元数据的简单示例:

A simple example to retrieve metadata from your universes in your cms:

• API URL:http://host:port/biprws/v1/cmsquery
• HTTP 方法:GET
• 数据格式:应用程序/JSON、应用程序/XML
• Headers:x-sap-logontoken(您也可以通过其余 api 检索登录令牌)

• API URL: http://host:port/biprws/v1/cmsquery
• HTTP Method: GET
• Data Formats: Application/JSON, Application/XML
• Headers: x-sap-logontoken (you can retrieve a logontoken via the rest api as well)

如果您使用 json，请使用以下请求正文:

if you use json use following request body:

{查询:select * FROM CI_APPOBJECTS WHERE SI_KIND='Universe' order by SI_NAME asc"}

{ query:"select * FROM CI_APPOBJECTS WHERE SI_KIND='Universe' order by SI_NAME asc" }

这个博客是一个很好的起点:https://blogs.sap.com/2017/05/10/query-the-businessobjects-repository-using-bi-platform-rest-sdk-rws/

This blog is a good place to start: https://blogs.sap.com/2017/05/10/query-the-businessobjects-repository-using-bi-platform-rest-sdk-rws/

这篇关于如何使用java从sap获取宇宙、类、对象、报告名称、报告字段的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！