首页 \ 问答 \ SAP BusinessObjects Crystal Reports - 数据源来自哪里？(SAP BusinessObjects Crystal Reports — Where does the data source come from?)

SAP BusinessObjects Crystal Reports - 数据源来自哪里？(SAP BusinessObjects Crystal Reports — Where does the data source come from?)

 我对（我相信是）关于SAP BusinessObjects / Crystal Reports存储他们的数据源的一个看似简单的理论问题茫然不知，以帮助我改变它们以与Maximo的新升级集成。  
 单句总结：我无法找到SAP BusinessObjects或Crystal Reports缓存其数据源信息的位置，因此我可以更改它; 我所能看到的只是一个数据源名称，并没有关于它的服务器/端口等。  
 简要背景：  
 
  我是Crystal Reports和Maximo的新手，但不是一般的企业系统，开发或报表  
  我来到一家使用水晶报表与IBM Maximo资产管理（在Oracle数据库上）集成的公司，  
  设置它的唯一家伙已经离开了，几乎没有文档  
  我基本上清理了这个烂摊子，但是我们正在经历一次升级，我必须了解这个系统才能在升级后进行工作。  
  我不能保证任何有关我们设置的内容都是“标准”或任何接近最佳做法的地方。  
 
 问题：  
 
  我们正在将我们的Maximo系统（5.2）升级到新版本（7.1）。  
  我们有约150个Crystal报表查询这些（旧的）系统，我需要指向新的数据库进行测试  
  当我查看单个Crystal报表（从文件系统打开）的数据源时，数据源似乎被缓存（只有数据源名称“Maximo”，用户名和PW在那里）。  
  我无法找到这个难以捉摸的“Maximo”数据源位于何处。 我在Crystal Report文件，SAP BusinessObjects Web站点或服务器上找不到任何东西，这些信息确实指向了数据库的实际位置，因此我可以对其进行更改。  
 
 我搜索过的地方：  
 
  对于服务器上的ODBC连接：这可能是有希望的，所以我是领先的，但我并没有从这里开始。 在oracle服务器上有一个名为“MAXPROD”的ODBC连接，但它也不表示服务器信息; 它只是说服务器是“MAXPROD”，带有用户名和密码字段。 没有关于连接的其他信息。  
  在Crystal Reports（.rpt）文件中：在数据源选择屏幕上，初始选项是选择数据源，但列出的所有数据源都与Oracle或Maximo相关（这很有意义，因为我的机器没有任何本地的DSN）。 但是，如果我点击“下一步”，我会看到带有SID（“MAXPROD”）的缓存服务器信息以及用户ID和密码字段。 没有提及服务器名称，端口，驱动程序，数据库类型等。它似乎是缓存的ODBC信息，但我不知道它存储的位置。  
  在.rpt文件的源代码中：没有运气，因为它不是文本文件。 我希望它可能是纯粹的XML。  
  在一个tnsnames文件中：我认为它是一个Oracle数据库，它可能存储在tnsnames.ora文件中，这是ODBC和Crystal可能要查找的文件。 但我发现的唯一tnsnames文件是样本或专门用于不相关的数据源（不同的服务器等）  
  在BussinesObjects XI CMC网站配置部分：再次，在这里我能够找到一个数据库连接，它允许我选择一个ODBC连接，但似乎有一个名为“MAXIMO”的缓存，我无法编辑。  
 
 我在我的智慧结束。 任何人都可以想到我没有看过的任何地方，或者实际上我是如何看待这种情况的？ 任何帮助将不胜感激。 

I'm flummoxed with (what I believe is) a seemingly-simple theoretical question about SAP BusinessObjects / Crystal Reports store their data sources, to help me change them to integrate with our new upgrade of Maximo. 
One Sentence Summary: I can't find where SAP BusinessObjects or Crystal Reports cache their datasource information so I can change it; all I can see is a datasource name and nothing about its server/port, etc. 
Brief background: 
 
 I'm new to Crystal Reports and Maximo, but not enterprise systems, development, or reporting in general 
 I came in to a company that uses crystal reports to integrate with IBM Maximo asset management (on an Oracle database) 
 The only guy who set it up is gone, with little or no documentation 
 I'm essentially cleaning up the mess but we're going through an upgrade and I have to understand this system to make it work post-upgrade. 
 I can't guarantee that anything about our setup is "standard" or anywhere near a best practice. 
 
The Problem: 
 
 We are upgrading our Maximo system (5.2) to a new version (7.1). 
 We have ~150 Crystal reports querying these (older) systems that I need to point to the new database to test 
 When I look at the data source for an individual crystal report (opened from the file system), the data source seems to be cached (only the data source name "Maximo", username and PW are there). 
 I can't find where this elusive "Maximo" data source is located. Nothing I can find in the Crystal Report file, in the SAP BusinessObjects web site, or on the server really points me to the actual location of the DB so I can change it. 
 
Places I've Searched: 
 
 For an ODBC Connection on the server: This could be promising so I'm leading with it, but I didn't start here. There is an ODBC connection on the server for oracle, called "MAXPROD", but it too doesn't indicate the server information; it just says that the server is "MAXPROD", with a username and password field. No indication of anything else about the connection. 
 In the Crystal Reports (.rpt) file: On the data source selection screen, the initial option is select data source, but none of the data sources listed are related to Oracle or Maximo (makes sense as my machine doesn't have any local DSNs). However, if I click "Next", I see cached server information with the SID ("MAXPROD") and a field for user ID and password. No mention of the server name, port, driver, DB type, etc. It appears to be cached ODBC information but I can't tell where it's stored. 
 In the source of the .rpt file: No luck, as it's not a text file. I was hoping it might be pure XML. 
 In a tnsnames file: I figured since it's an Oracle DB, it might be stored in a tnsnames.ora file which is where the ODBC and Crystal might be looking. But the only tnsnames files I found were samples or were specifically for unrelated datasources (different servers, etc.) 
 In the BussinesObjects XI CMC web site configuration section: Again, here I am able to find a database connection, where it allows me to select an ODBC connection, but appears to have one cached called "MAXIMO" that I can't edit. 
 
I'm at my wits end. Can anyone think of anywhere I haven't looked, or is the problem actually how I'm looking at the situation? any help would be greatly appreciated.

原文：https://stackoverflow.com/questions/7894898

更新时间：2023-08-20 17:08

最满意答案

 尝试这个  
private void btnAdd_Click(object sender, RoutedEventArgs e)
{
    WebClient proxy = new WebClient();
    proxy.DownloadStringCompleted += new DownloadStringCompletedEventHandler(proxy_DownloadStringCompleted);
    proxy.DownloadStringAsync(new Uri(""));
}
 
 并且需要解析返回的JSON，如下所示。 在创建DataContractJsonSrrializer实例的参数中，我们传递了List of Student。  
void proxy_DownloadStringCompleted(object sender, DownloadStringCompletedEventArgs e)
{
    Stream stream = new MemoryStream(Encoding.Unicode.GetBytes(e.Result));

    DataContractJsonSerializer obj = new DataContractJsonSerializer(typeof(List<Student>));
    List<Student> result = obj.ReadObject(stream) as List<Student>;
    lstStudents.ItemsSource = result;
}

what exactly you need to do is take array element return as a DataContract and its sub member as DataMember as  
[DataContract] 
public class mainresponse
 {
 [DataMember]
 public resultmap arrayelement { get; set; }
 }  
 [DataContract]
 public class resultmap 
{
 [DataMember] 
 public string substringhere { get; set; } 
 }     
 var djson = new DataContractJsonSerializer(typeof(Mainresponse));
 var stream = new MemoryStream(Encoding.UTF8.GetBytes(responsestring));
 mainresponse result = (mainresponse)djson.ReadObject(stream);  
 
that it...

SAP BusinessObjects Crystal Reports - 数据源来自哪里？(SAP BusinessObjects Crystal Reports — Where does the data source come from?)

最满意答案

相关问答

反序列化json数组以列出wp7(deserialize json array to list wp7)[2023-01-07]

使用DataContractJsonSerializer WP7将数组解析为Json字符串(parse an array as a Json string using DataContractJsonSerializer WP7)[2022-03-31]

JSON在WP8中反序列化(JSON Deserialize in WP8)[2022-03-04]

如何反序列化一个没有名字的JSON数组？(How to deserialize a JSON array with no name?)[2022-02-21]

C＃/ WP7：使用包含JSON对象数组的JSON对象(C#/WP7: Working with a JSON object that includes an array of JSON objects)[2021-10-22]

C＃/ WP7绑定到包含JSONNet的JSON数组的对象？(C#/WP7 binding to an object containing JSON Arrays from JsonNet?)[2023-04-25]

无法反序列化JSON数组(Cannot deserialize the JSON array)[2022-03-14]

无法反序列化当前的JSON数组(Cannot deserialize the current JSON array)[2022-08-03]

JSON Jackson序列化反序列化列表(JSON Jackson serialize deserialize List of List)[2022-02-15]

无法反序列化当前的JSON数组(Could not deserialize the current JSON array)[2022-11-22]

相关文章

最新问答