Tag: Vertabelo Features

New Vertabelo Feature: Document-Oriented Vertabelo API

Find out how to use the new Vertabelo Public API to access data models, SQL scripts, and more. One of the signs of a decent SaaS solution is its public API. A good API helps users to incorporate some automation into an application. Based on our experience in using other SaaS services, we have introduced a more document-oriented version of our public API. In this article, we will demonstrate how to use Vertabelo API to fetch a list of documents (models), SQL scripts, and data models in various formats.

Reverse Engineering With Vertabelo

Learn how to import your database into Vertabelo and generate its data model with our improved reverse engineering feature. We’re excited to announce the release of a new version of our popular reverse engineering tool. You've been asking for a user-friendly interface, and we heard you. If working with Java is not your thing, our new graphical user interface lets you click through the process in no time.  Download the upgraded reverse engineering tool here.

Vertabelo Feature: Amazon Redshift Support in Vertabelo

Find out how to design an Amazon Redshift schema in Vertabelo. Thanks to increasing volumes of data, analytical databases like Amazon Redshift are gaining market. We introduced Redshift support at the end of 2019; in this article, we will explain how to design a Redshift data model using Vertabelo. How to Create a Model Let's start with the data model creation process. To create a Redshift schema, please: Log into Vertabelo and click on Create new document.

Top 7 Entity Relationship (ER) Diagram Online Tools

Are you searching for the best online ER diagram tool? Read on and discover our top picks. Data modeling is one of the most critical parts of a software project. Database architects use ER diagrams (also called ERDs or Entity Relationship Diagrams) as a data modeling technique. Many ER diagram tools are available, but choosing the best tool for your project can be hard. Still, your data model is a key factor in the success of your entire project; it’s important to get it right.

2020 Was Vertabelo Database Modeler’s Year. It’ll Get Even Better in 2021.

2020 is coming to an end. It's been a busy year for us, so let's summarize what we did at Vertabelo. I will also show you how the Vertabelo database modeler will evolve in 2021. This is already a great tool, but it will be even better. See what we plan to do. I am not exaggerating when I say that we had our hands full in 2020. In addition to constantly improving the Vertabelo database modeler and creating new Vertabelo Academy courses, we have launched completely new platforms for learning SQL and Python.

Explaining an ER Diagram, With Steps and Use Cases

Get to know what an ER Diagram is through use cases and examples. Explore the notations for the essential components of an ERD. Entity-relationship diagrams (ERDs) are used to visualize data and relationships among the entities of a system. At its core, an ER Diagram explains the logical structure and the flow of information within a data model. To do so, an entity-relationship diagram highlights entities, attributes, and relationships through predefined symbols for effective visualization of the architecture.

Vertabelo Features: Logical Diagrams

Find out how to create logical data models in Vertabelo! If you have some experience with physical diagrams, this will be as easy as pie. There are three different levels of data models: conceptual, logical, and physical. Of these, the conceptual model is the most abstract, and the logical model has a few more technical details. The physical model has all the details of the physical database, such as data types (integer, decimal, money, varchar, etc.

Using Vertabelo’s SQL Script Editor

Vertabelo’s new SQL Script tool lets you write and save SQL scripts and run them against a connected database. Creating an SQL Script Start by clicking on the Create Document button. It’s the first one on the main toolbar. The New Document window appears. Now select SQL script and click on the Create button. The New SQL script window will be displayed. Name your script using the Name field and click the CREATE button.

Hot: Vertabelo Now Features Migration Script Generation

The long-awaited generation of SQL migration scripts is now a part of Vertabelo! You can use these scripts to easily move from one database model version to another. Read this article to learn more. What are SQL Migration Scripts? An SQL migration script is a script that alters an existing database structure: it can add or drop a table, rename columns, or change column types. A migration script can change a given database from one schema version to another – hence its name.

Generate Your Model Documentation with Vertabelo

Vertabelo has a great new feature: a model documentation auto-generator. You can now create and export documentation for your current model with just a few clicks. Vertabelo has a great new feature: a model documentation auto-generator. You can now create and export documentation for your current model with just a few clicks. Think of how a complex model looks: multiple tables and tens or hundreds of columns where you can easily get lost.

Vertabelo XML Version 2.3

The XML file format for Vertabelo has changed to version 2.3. Read this article to find out what is new. Vertabelo keeps its models in XML format; if you need, you can download the files and extract information from them. Previously, we used XML version 2.1, as discussed in this article. We’ve switched to XML 2.3, and a couple of changes took place. These changes make no difference for most Vertabelo users.

How to Embed Your Database Model Into a Website

Did you know that you can embed your database model in your website? If you haven’t tried this yet, now’s your chance – we’ve recently improved the process. It’s an excellent way to share ideas with readers or make projects available to co-workers. You might have already seen some interactive models embedded in our blog. They look like this: if (typeof VertabeloEmbededObject === 'undefined') {var VertabeloEmbededObject = "loading";var s=document.createElement("script");s.setAttribute("type","text/javascript");s.setAttribute("src", "

Tip #19 – How to automatically download SQL script from Vertabelo

If you need to automatically download SQL script from Vertabelo, for example, for the purposes of your build system, you definitely should check out our Vertabelo API. It allows you to download an SQL or XML of your model by a simple HTTP request. In the command line, it may look like this: VERTABELO_API_TOKEN=put-your-api-token-here MODEL_ID=put-your-model-identifier-here curl -u $VERTABELO_API_TOKEN: \ https://my.vertabelo.com/api/sql/$MODEL_ID create-database.sql To learn more about Vertabelo API, go here.

Tip #14 – How to create a model preview link and embed the model in a website

When it comes to sharing things like documents or photos with other people, sending files to each other is becoming less and less common – we usually prefer to send links. They are quick, convenient and neither use up disk space nor make a mess in our file system. At Vertabelo, we know how inconvenient it can be to send files and that’s why we created public links for models.

Remote Collaboration on Database Design Just Got Easier

As an SQL consultant, I often work with others to create new database models from scratch or modify existing schemas. Aside from the technical aspects, collaborations on database models can be tricky. Moving from environment to environment poses its own challenges: security restrictions sometimes prevent direct access to SQL instances, and technical resources from across the globe can be difficult to seamlessly integrate. Deterrents these may be, but they are not insurmountable.

Generate jOOQ Classes With Vertabelo and Gradle

jOOQ is a Java Object-Relational Mapper that lets you build type safe SQL queries through its fluent API. Using built-in Vertabelo support we can generate sufficient code from the previously designed model. Generated Java classes correspond to database tables, records, etc. This time, we automate this process by using Gradle build system. There are two ways to generate ready to use Java classes with Vertabelo: Generate jOOQ classes via Vertabelo XML Generate jOOQ classes via Vertabelo API Generate jOOQ Classes via Vertabelo XML Design your database model online in Vertabelo.

Defining Identifying and Non-Identifying Relationships in Vertabelo

Various data modeling tools allow modelers to define relationships in a data-model as identifying or non-identifying. We can define a relationship as identifying or non-identifying in Vertabelo as well. This article will explain the way to do so. Introduction Before moving ahead with the article, I’d like to explain what identifying or non-identifying mean. Let’s take a real time example of a book storing system. In the system, a book belongs to an owner, and an owner can own multiple books.

Generate jOOQ Classes With Vertabelo and Maven

jOOQ provides an easy way to automate the process of generating the java classes that represent database tables, records, etc. via the jooq-codegen-maven plugin. This time we let Maven worry about downloading the required JAR files and generating Java code that lets you build typesafe SQL queries through jOOQ’s fluent API. There are two ways to generate ready to use Java classes with Maven and Vertabelo: Generate jOOQ classes via Vertabelo XML Generate jOOQ classes via Vertabelo API Generate jOOQ Classes via Vertabelo XML Design your database model online in Vertabelo.

jOOQ and Vertabelo – Getting Started

jOOQ and Vertabelo perfectly complement each other in the application development lifecycle. With Vertabelo you can easily design a database structure that saves you from writing DDL code manually, while jOOQ handles the generation of Java classes corresponding to database tables, and allows to construct SQL queries through its fluent API. The integration of Vertabelo and jOOQ has been the subject of several articles published on our blog. Unfortunately, all of them, including “The easiest ERD + ORM integration ever: Vertabelo and jOOQ”, are intended for users having some previous experience with jOOQ.

How to Convert a Data Model Between Two Database Management Systems

Even though Vertabelo doesn’t provide a direct conversion of a data model from one database engine to another, this can be easily done in a few simple steps. The user’s question We’ve been developing a web application for a while. Initially, we wanted to use MySQL for our database but finally we decided to choose Postgres. Unfortunately, the entire data model was created for MySQL. How can we quickly migrate it to the new database type?

New Features in Vertabelo Released in April 2015

Tell us what you want! If you have your own ideas for new features or you think that something could be improved in our application, do not hesitate to share your opinion. Send your suggestions to us via our Support Service. There, you can upvote or downvote new feature requests placed by other users. That way, you can have a significant impact on the development of our application. Go to Vertabelo's Support Service »

How to Generate Flask-SQLAlchemy Models Using Vertabelo

Flask is a web microframework for Python. It uses Flask-SQLAlchemy for object relational mapping. It is a Flask wrapper for SQLAlchemy – a powerful relational database framework that offers a high level ORM and low level access to a database’s native SQL functionality. For each database table, SQLAlchemy uses a regular Python class with attributes that match the columns of a corresponding database table. The database instance from Flask-SQLAlchemy provides a base class for models called db.

Designing & Deploying a PostgreSQL Database in the Cloud

Our users sometimes say to us: “Vertabelo is awesome but... how can I add the data?” Oh, come on! Vertabelo is not a database engine or a database administration tool. At least not at the moment. For now, Vertabelo is intended mainly to design database models. This doesn't mean that we don’t care about what you can do next with models created in our application. Of course, we do! That’s why we provide our users with some useful tools on our website and in our GitHub repository.

How to Color ERD Diagrams in Vertabelo

If you’ve ever had to design a database model with hundreds of tables, views and references, you know very well how difficult is to make such huge diagram readable and comprehensible. One of the possible solutions is to use some colors to distinguish different groups of tables or subject areas. See how Vertabelo allows you to do this quick and easy. To illustrate how you can color your entity relationship diagram to increase its readability, we will use a sample uncolored database model for a simple online store:

How I Use the Vertabelo API With Gradle

What is Gradle? Gradle is an open source build automation system. It can automate the building, testing, publishing, deployment and more of software packages or other types of projects such as generated static websites, generated documentation or indeed anything else. Learn more about what makes Gradle a compelling choice for build automation. One of the exciting moments in a programmer’s life is to leave legacy code behind and have fun with some new, fresh and cool tools.

Data Dictionary Support: Generate Comments for Your Database

Most relational databases allow you to define comments for their tables, columns, views, and so on. These additional pieces of information are called database meta data or data dictionary. Meta data may be useful for developers or other database users. Meta data allow the development team to understand what various tables or columns are for without having to ask database designer what their intentions were. Generating meta data in SQL scripts is one of the most often requested Vertabelo features and it’s finally here.

How to Generate Propel’s Schema.xml File From a Database Model Created in Vertabelo

If you use Propel, you can now generate a Propel schema file from a database model created in Vertabelo. Propel is a popular ORM (Object-Relational Mapping) library for PHP. In Propel, the datamodel structure is described by a special schema XML file. From this schema Propel generates PHP object model classes which Propel uses to represent rows in your tables. VertabeloPropel is a PHP script which converts a Vertabelo XML file into Propel’s schema.

Now You Can Print a Diagram

We hadn’t planned on adding a feature to print diagrams. Our original idea was that Vertabelo would supersede paper diagrams. Nevertheless, some of our users pointed out that they rely heavily on printouts (Export to PDF topic). So, I’d like to announce a new feature called “Export to PDF” also known as “Printing.” Note that exporting a database model to a PDF file is available for Premium and Team account plans only (see the comparison of the plans’ features in our Pricing).

Vertabelo XML version 2.1

Vertabelo internally stores your model in an XML format. You can download the XML file and use it to extract some information by using a script. Let’s take a look at the structure of this XML file. if (typeof VertabeloEmbededObject === 'undefined') {var VertabeloEmbededObject = "loading";var s=document.createElement("script");s.setAttribute("type","text/javascript");s.setAttribute("src", "https://my.vertabelo.com/js/public-model/v1/api.js");(document.getElementsByTagName("head")[0] || document.documentElement ).appendChild(s);} Here is the XSD file and an example of the XML file for the above sample database model created in Vertabelo.

Vertabelo API

.border-radius-5px { border-radius: 5px; } Generating a token We've added an API to our Vertabelo application to help you incorporate some automation into your build system. Here is a short instruction on how to use the Vertabelo API. First of all, you have to enable access to the API. You'll need have at least a "Basic" account plan or be a member of a company. Go to the My account page.

How to filter tables in the Vertabelo reverse engineering tool

Sometimes you don't want the reverse engineering tool to extract all of the tables in your database. For example, the database may contain technical tables which are logically are not part of the model. This is when the -regexp option comes in handy. Use the -regexp option and the tool will extract all tables and views with names matching the regular expression. The tool prints the regular expression it uses so you can verify that your shell parsed the expression correctly.

Some bits about the Vertabelo user interface

I'd like to write something about the Vertabelo user interface. Don't really know what to cover in this article. A user manual for a rich GUI application is an oxymoron to me. No one reads it and no one should write it. On the other hand, it is too early to write about the libraries that we used. The time is needed to sum up the experience. So, I gotta share with you some inspirations how they affect Vertabelo.

How to import an existing database into Vertabelo: Reverse Engineering

The newest Vertabelo feature is Reverse Engineering: a way to import an existing database into Vertabelo. The Reverse Engineering tool is a simple command-line Java application that you can download from our website. It connects to your database, reads the table and view details and stores the info in an XML file. Import the XML file into your database model and voila - your database is in Vertabelo! How to use the reverse engineering application Download the Reverse Engineering application from our website, then run the Reverse Engineering application.

How to embed a database diagram on the Internet

So I’m sitting here thinking to myself: How should I share a new Vertabelo feature with you? Should I write an over-hyped article full of industry jargon and marketing-speak? Hmmm. Tried and failed. I’ve just gotta show you the feature straight up and how simple it is to use. More meat, little fat, no fluff :). Well tah dah! Here it is: Go ahead, click on it. Use the mouse wheel to zoom.

Good news: we now support views

Today we are happy to announce that Vertabelo has a new feature we've been working on for some time – views. Now you can easily add them to the diagram, change their definition and other properties and have them generated in your SQL scripts. Quick overview of views Let's take a look at how simple it is to create a new view in our editor. Our goal is to make a view which joins three tables as follows:

Five reasons why we built Vertabelo

We are launching a new product on a market, so let me tell you the short story about how and why Vertabelo was born. e-point and I personally have more than fifteen years of experience in building business applications. All of them use relational databases as a storage for their data. Most of those applications are rather big - think about hundreds of tables in a database and hundreds of screens in a UI.