用于在SAP HANA中生成模式的ER建模工具

Is there any good ER Modelling tool available for SAP HANA , which accomplishes the following :

是否有适用于SAP HANA的良好ER建模工具，它可以完成以下任务：

Creation of ER Diagrams
创建ER图
Generating HANA specific SQL Scripts
生成HANA特定的SQL脚本
Connecting to HANA DB Instance
连接到HANA数据库实例
Generating all schema objects modelled
生成建模的所有模式对象

TIA

2 个解决方案

#1

The Web IDE for SAP HANA that was delivered with XS Advanced in SAP HANA 2.0 SP01 sounds like what you are looking for as it has a graphical editor to create and link database entities (this is what it looks like):

与SAP HANA 2.0 SP01中的XS Advanced一起提供的SAP HANA Web IDE听起来与您正在寻找的一样，因为它具有用于创建和链接数据库实体的图形编辑器（这就是它的样子）：

Core Data Services graphical editor Web IDE for SAP HANA

适用于SAP HANA的Core Data Services图形编辑器Web IDE

With XS Advanced, the model is container-based and schema-less.

使用XS Advanced，该模型基于容器且无模式。

Here are a couple of links if you would like to try it out:

如果你想尝试一下，这里有几个链接：

Getting started with XS Advanced (in the HDI step, right click on any of the .hdbcds files and you will have the option to open it in the graphical editor): https://www.sap.com/developer/groups/hana-xsa-get-started.html

XS Advanced入门（在HDI步骤中，右键单击任何.hdbcds文件，您可以选择在图形编辑器中打开它）：https：//www.sap.com/developer/groups/hana -xsa-GET-started.html
If you need to integrate a database schema from XS Classic or, for example, an ERP replicated schema, you can search for xsa-create-user-provided-anonymous-service in the same site

如果需要集成来自XS Classic的数据库模式，或者例如ERP复制模式，则可以在同一站点中搜索xsa-create-user-provided-anonymous-service

As for "HANA-specific SQL scripts", it depends on what you are trying to do. If you want to access data in an optimized way and perform calculations, you can use Calculation Views, which are built graphically and the DB will do the equivalent to SQL under the hood. There are some tutorials in the developer[dot]sap[dot]com website, under the Developer->tutorial menu.

至于“HANA特定的SQL脚本”，它取决于您尝试执行的操作。如果要以优化的方式访问数据并执行计算，可以使用计算视图，这些计算视图是以图形方式构建的，而DB将在底层执行与SQL相同的操作。开发人员[dot] sap [dot] com网站上的Developer-> tutorial菜单下有一些教程。

If you do not have a HANA instance to try this and/or EA designer you can download your own HANA instance for free:

如果您没有HANA实例来尝试此设置和/或EA设计器，则可以免费下载自己的HANA实例：

Download SAP HANA, express edition (you will need the XS Advanced tooling that includes the Web IDE for SAP HANA): sap[dot]com/developer/topics/sap-hana-express.html

下载SAP HANA，快速版（您将需要包含适用于SAP HANA的Web IDE的XS Advanced工具）：sap [dot] com / developer / topics / sap-hana-express.html
If your computer does not have enough resources to comfortably host your HANA instance, there's a blog on how to install it in a cloud platform using a free operating system, search for hana-express-edition-on-google-cloud-platform-and-ubuntu (sorry, I cannot post any more links).

如果您的计算机没有足够的资源来轻松托管您的HANA实例，那么有一个关于如何使用免费操作系统在云平台上安装它的博客，搜索hana-express-edition-on-google-cloud-platform-and -ubuntu（抱歉，我无法发布更多链接）。

Cheers!

干杯!

#2

There are two tools from SAP: SAP (Sybase) Powerdesigner, also supporting different other DBs, e.g. for reverse engineering. With Powerdesigner you can model conceptual, logical, physical Data models and also generate a HANA DB schema in different ways, e.g. by generating scripts containing "create..." statements or CDS files. Then there is the Enterprise Architecture Designer which can be installed as addon in HANA XS advanced starting with HANA 2.0. This tool is quite new and I have not worked with it yet. There are probably also tools from other vendors.

SAP提供了两种工具：SAP（Sybase）Powerdesigner，也支持不同的其他数据库，例如：用于逆向工程。使用Powerdesigner，您可以对概念，逻辑，物理数据模型进行建模，并以不同方式生成HANA数据库架构，例如：通过生成包含“create ...”语句或CDS文件的脚本。然后是企业架构设计器，可以作为插件安装在HANA XS高级版中，从HANA 2.0开始。这个工具很新，我还没有使用它。可能还有来自其他供应商的工具。

#1