在 Oracle SQL developer 中使用 Data Modeler(查看关系图)

声明:本页面是StackOverFlow热门问题的中英对照翻译,遵循CC BY-SA 4.0协议,如果您需要使用它,必须同样遵循CC BY-SA许可,注明原文地址和作者信息,同时你必须将它归于原作者(不是我):StackOverFlow 原文地址: http://stackoverflow.com/questions/2287239/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me): StackOverFlow

提示:将鼠标放在中文语句上可以显示对应的英文。显示中英文
时间:2020-09-18 20:01:19  来源:igfitidea点击:

using Data Modeler (view relational diagram) in Oracle SQL developer

oracleoracle-sqldeveloper

提问by Stan

when trying to view 'Reports > Data Modeler Reports > Design Contents > Relational Model > Relational Designs' in Oracle SQL developer. It gives "Data Modeler reporting repository required." Can anyone see what's wrong with it? Thanks a lot!

尝试在 Oracle SQL 开发人员中查看“报告 > 数据建模器报告 > 设计内容 > 关系模型 > 关系设计”时。它提供了“所需的数据建模器报告存储库”。任何人都可以看到它有什么问题吗?非常感谢!

alt text

替代文字

回答by Tony Andrews

You need to create a reporting repository schema like this:

您需要像这样创建一个报告存储库架构:

SQL> create user DM_REPORT_REPOS identified by DM_REPORT_REPOS;

User created.

SQL> grant connect, resource to DM_REPORT_REPOS;

Grant succeeded.

Then in SQL Developer Data Modeller you can open the model you want to report on and export it to this repository via File/Export/To Reporting Schema. You will need to create a new Connection for the schema you just created.

然后在 SQL Developer Data Modeller 中,您可以打开要报告的模型,并通过 File/Export/To Reporting Schema 将其导出到此存储库。您需要为刚刚创建的架构创建一个新的连接。

Then in SQL Developer you can also create a new Connection for the repository and select this to run the reports.

然后在 SQL Developer 中,您还可以为存储库创建一个新的连接并选择它来运行报告。