Eclipse Foundation Member
g9 Database Import

Add this URL to your Eclipse Installation to reach this solution's update site.

2018-09 (4.9)
Photon (4.8)
Oxygen (4.7)
Neon (4.6)
2018-12 (4.10)


Learn more...

Details Group Tabs

Details

Do you need to create Java classes, or an Xcore or Ecore representation of your exisiting database? g9 Database Model Import is a free g9 Eclipse plugin producing models based on structure information read from databases.

Given a connection to an existing database, the g9 Database Import will read tables and columns in your database (using the database schema) and create the corresponding model either in Java, Xcore or Ecore depending on the project type of your Eclipse project.

Install g9 Database Import, restart Eclipse and create a Java or Xcore project. Select File > Import... > g9 > Import Database Model to start the import wizard (see the Screenshots).

Complete documentation is available from Help > Help Contents. Select g9 Documentation >  g9 Database Model Import.

Choose

  • which tables to include: by default all tables are included and a class name based on the table names are suggested
  • which columns to include: by default all columns are included and an attribute name based on the column names are suggested
  • the data type mappings for your domain model based on the JDBC types - or use default values

An import of your database to a Java Project will create Java classes, an import to an Xcore Project will create an Xcore model, all other Eclipse Project types will result in an Ecore model. The Java classes may be enriched with JPA annotations. If you work with Xcore or Ecore models you should use Eclipse for Java and DSL Developers.

In the g9 Database Import feature you connect to a database using a JDBC driver. The built-in drivers are MySQL, MS SQL Server (jTDS) and Sybase ASE (jTDS). Use the function [Maintain JDBC Drivers] in the g9 Import feature to connect to other databases, e.g Oracle, PostgreSQL, Firebird or a DBMS of your choice.

You may download the complete g9 product and use the Database import feature in a g9 Eclipse Project. To be able to exploit the other features in g9, you should create a g9 UI Modeling Project and import your database to an Ecore, Xcore model or Java source with g9 annotations. Please see the User guide for more information about the g9 Database Import feature.

Additional Details
Eclipse Versions: 
2018-09 (4.9), Photon (4.8), Oxygen (4.7), Neon (4.6), 2018-12 (4.10)
Platform Support: 
Windows, Mac, Linux/GTK
Organization Name: 
Date Created: 
Wed, 2016-09-14 09:30
Development Status: 
Production/Stable
License: 
Commercial - Free
Date Updated: 
Tue, 2018-11-27 10:27
Screenshots
Metrics
DateRankingInstallsClickthroughs
December 2018367/88737 (0.02%)13
November 2018385/93981 (0.01%)25
October 2018385/94384 (0.01%)17
September 2018396/94169 (0.01%)15
August 2018438/93951 (0.01%)8
July 2018471/94043 (0.01%)17
June 2018423/94757 (0.01%)21
May 2018477/95446 (0.01%)12
April 2018484/94642 (0.01%)9
March 2018508/96136 (0.01%)12
February 2018443/94051 (0.01%)9
January 2018415/94561 (0.01%)16
View Data for all Listings
Errors
External Install Button

Marketplace Drag to Install button

By adding the following code below to your website you will be able to add an install button for g9 Database Import.

HTML Code:


Markdown Syntax:



Output: Drag to your running Eclipse* workspace. *Requires Eclipse Marketplace Client
Wednesday, December 12, 2018 - 01:06
pmobedi's picture

This library does not show on my Marketplace for some reason. And when I drag the button via the browser, I only get the Featured libraries in the Marketplace client. Does any have the same issue?

OS: macOS High Sierra Version 10.14.4

Eclipse: Oxygen.2 Release 4.7.2

pdigre's picture

Try now. ;-)

pdigre's picture

Have you clicked "Accept cookies" on the Eclipse Marketplace web-page? Before I did that, it returned a blank Marketplace page when dropping the link onto Eclipse. I also have OSX.

pmobedi's picture

I have accepted cookies and I have already downloaded many plugins via the marketplace. The problem is I do not even get an error message. It seems as if the marketplace ignores the plugin and shows the default recommended list instead. I'd like to know if others have had this problem, too.

pmobedi's picture

I have Eclipse Oxygen.3a Release (4.7.3a) installed and have created a Spring Data project using Spring Initializer with JPA and SQL Server dependencies. This library does not show up in the Marketplace when I search for it. So I scroll all the way down and click on "click for more solutions". This opens a tab in the Eclipse web browser in which I see the g9 Database Import in the search results. So I click on "Install". The marketplace is opened with no g9 in the results. This is slightly confusing. 

pdigre's picture

I am not sure where the problem lies. As a backup solution you can try our updtate site http://updatesite.esito.no/dbimport. Have a look at our support/download site http://www.esito.no/en/download/ for further instructions.