您可以从 Cognos 8.3 导出打包信息(ERD 或其他数据模型)吗?
我想知道是否有一种方法可以从常规用户级别或框架级别从 Cognos 8 导出包信息。
例如,我想要 cognos 在数据库上指向的字段名称、数据类型、右键单击数据元素时 cognos 使用的描述等。
有什么建议吗?
I was wondering if there's a way to export package information from Cognos 8 from a regular user level or from the framework level.
For instance, I want the field names that cognos is pointing to on the database, i want the datatype, the description cognos uses when you right click a data element, etc..
Any suggestions?
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(3)
(遗憾的是我现在不在工作计算机旁)但是 Cognos 将所有内容保存在 .xml 文件中。 我有一个 xml 漂亮的打印机,在编辑之前和之后在 model.xml 上使用,这样我就可以使用 Windiff 来查看模型中到底发生了什么变化。 我还多次在 model.xml 上使用 xml 编辑器进行全局搜索和替换。
话虽如此,我不确定您可以直接从 model.xml 推断出多少数据库架构,但我怀疑您是否有一个可以读取和遍历 model.xml 并连接到数据库来描述对象的脚本,你可以获得你所需要的。
(Unfortunately I'm not at my work computer right now) but Cognos saves everything in .xml files. I have an xml pretty printer that I use on model.xml before and after edits, so that I can use windiff to see what exactly changes in the model. I have also used an xml editor on model.xml on several occasions for global search and replace.
Having said that, I'm not sure how much of the database schema you can infer directly from model.xml, but I suspect if you had a script that could read and walk model.xml, and connect to the database to describe the objects, you could get what you need.
答案似乎是是的,任何支持 CWM 的东西(Common Warehouse模型),但至于如何...
一个建议:询问 IBM。
The answer appears to be yes, to anything that supports CWM (the Common Warehouse Model) but as for how...
One suggestion: ask IBM.
看来Powerdesigner 15是从xmi型号导入的。
It appears that Powerdesigner 15 imports from xmi models.