The Data modeling tool family enables Oracle Data Modeler to support Vertica

Introduction

The evaluation of several modeling tools was highlighted in the previous blog, and SQL Power architect was selected as the final modeling tool, and the Oracle Data Modeler support Vertica was also studied during the evaluation process, although the eventual abandonment of Oracle data Modeler, but the scalability of Oracle Data Modeler is worth blogging.

Software download location

Software official website: http://www.oracle.com/technetwork/developer-tools/datamodeler/overview/index.html

, the latest version is 17.3.

Increase Vertica-specific data types

Oracle Data Modeler does not directly support Vertica, but Oracle Data Modeler has good extensibility. Considering that SQL Server 2012 is not commonly used, and the data type/sql syntax is similar to Vertica, we choose SQL Server as the basis for the Vertica extension.

Manual modification of the way

In the menu "Tools"/"type Management", first in the "User Defined native Type" tab, select SQL Server 2012, add some vertica specific data types, such as the Boolean type, internal two types.

Then on the logical type to native Type tab, modify its mapping in SQL Server 2012 for types such as Boolean, modify the mappings from bit to Boolean, and the two types of internal make the same modifications.

After such modifications, the data tables in the model can use the Vertica unique data type.

How to import changes

Manually modify the mapping of the data type, the procedure is too cumbersome, here is an easy way to import the following files into the types subdirectory of the Datamodeler installation directory.

Types.xml File Links: https://files.cnblogs.com/files/harrychinese/types.xml

For example, on my machine, the final location of the file is:

D:\my_program\datamodeler-x64-17.2.0.188.1059\datamodeler\datamodeler\types\types.xml

Import a new relational model from table in the Vertica database

Select a database type of SQL Server 2012,

Add Vertica JDBC Driver

In the menu "Tools"/"preferences", you can add Vertica jdbc jar files.

Importing tables in Vertica DB

Click the menu "File"/"Import"/" Data dictionary ", there is an import wizard, follow the instructions,

Add a Vertica database,

After adding the database, click Next to select the table to import.

Model examples

The Data modeling tool family enables Oracle Data Modeler to support Vertica