What’s new in 2.3.2

 

What’s new in Datanect 2.3.2


Data Source Explorer


Bugfixes
  • [DATANECT-286] NPE when importing DB2 database
  • [DATANECT-287] Add support for database aliases

Entity repository explorer

Bugfixes
  • [DATANECT-287] Reload entity repositories does not work

What’s new in 2.3.1

 

What’s new in Datanect 2.3.1


Tablebrowser


Got to next and previous selection

You can now use the next and previous buttons to jump to
the next or previous selection.


Export to workspace

You can now choose a workspace location within the export
dialog.


Data Tools Explorer

Import data sources from other systems

You can now use the import data sources button to import data
sources from other systems. Squirrel is currently supported.

First click on the import data sources button in the toolbar.

Select the data sources you want to import.

Check and configure.

 

What’s new in 2.3

 

What’s new in Datanect 2.3


Tablebrowser


Open long text, like CLOBs, in text editor

If an entity class contains attributes that contain long text you can now open the full text in a text editor. Choose Attributes-> Open with text editor -> <attribute name> from the context menu.

Datanect will load the complete attribute value and opens it in the text editor


Bugfixes

Load performance for big tables improved


Entity Repository Explorer


Entity remote count

You can now select Count -> Entities from the context menu if you select:

  • Datanect Project
  • Entity Repository
  • Entity Namespace
  • Entity Class

Datanect will then count the entities in the remote repository and provide the result as an decorator.

The entity count actions are also available in the toolbar.


Keep user-defined attributes on repository reload

You can now select which uder-defined attributes to keep on reload.


License Management


Bug fixes
  • Update notification did not work.

Export


Bug fixes
  • [DATANECT-277] – Excel export fails when cell value is greater then 32767

 

What’s new in 2.2

 

What’s new in Datanect 2.2


Log Console


RDBMS statement log

The SQL statements that are send to the remote repository
are loggen in the RDBMS console.


Tablebrowser


Attribute filters extended

The attribute filters do now allow the !, >, >=,
<, <= operators


Multiple attribute filters values

Mutiple attribute filter values can be used for integer
values.


Null filter

You can now filter null attributes using
null


Copy cell value support

Selected cell values can now be copied into clipboard via
the context menu.


Copy cell value via double click

Double click a cell and select the text you want to copy.
Then press CTRL + C.


Attribute search

You can search an open tablebrowser’s attributes and
scroll to the selected now. Use CTRL + SHIFT + A


Bugfixes

DATANECT-232: Derived attributes do not allow big_integer
types.

DATANECT-243: When a derived attribute is deleted all
user-defined references that use them should be deleted too.

DATANECT-254: Selection is not propagated through
user-defined references.

DATANECT-256: Do not open another tablebrowser for the
same reference.


Entity Repository Explorer


Keep user-defined references on reload

When you reload an entity repository that contains
user-defined references, you will be asked which ones you would
like to keep.


Network Settings


Proxy settings

You can now configure a proxy server. You might need this
to activate a license or to check for updates. Use Window ->
Preferences -> General -> Network Connections


License Management


Bug fixes
  • [DATANECT-246] – License management should use proxy
    settings if set.

Check for available updates

The license management now provides a check for updates button.


Export


Bug fixes
  • [DATANECT-242] – CHAR(10) is exported as CHAR(1)

Update notification


Check for available updates on startup

Datanect will automatically search for updates in the
background at startup and show you an available updates dialog
if updates are available.

What’s new in 2.1

 


Entity Management


Derived attributes

Datanect now allows you to create derived attributes.
Derived attributes are be defined in the entity repository’s
specific query language. For now only RDBMS repositories are
supported. You can specify them e.g. in SQL.


Derived attributes in user-defined references

Derived attributes can also be used as source or target
attributes in user-defined entity references. This extends your
options when connecting data.


Datanect perspective


Type search for entity classes

You can open the type search dialog for entity classes
find and open entity classes more quickly. The selected entity
class will be opened in the tablebrowser.

 


Full quallified entity class name

The tablebrowser shows you the full qualified entity class
as the tab’s tool tip now.


Tablebrowser


User-defined attributes

User-defined attributes can be created through the
tablebrowser’s context menu


Comma-separated values for integer filters

The tablebrowser’s attribute filters allow comma-separated
list for integer types.


Full quallified entity class name

The tablebrowser shows you the full qualified entity class
as the tab’s tool tip now.


Invert selection

You can now invert the actual selection in the
tablebrowser through the context menu.


Sort columns

You can now sort the tablebrowser’s column. The sort will
only be applied to the tablebrowser’s actual content. It will
not be applied to the remote repository. E.g. by using an order
by SQL. This feature is planned for a later release.


Bug fixes
  • [DATANECT-221] – Selection takes a long time for large
    entity sets.

Bug fixes
  • [DATANECT-200] – CHAR based entity attributes are cut to 1 char

Entity Repository Explorer


User-defined markers

The Entity Repository Explorer shows an user-defined marker on entity
classes that either contains user-defined references or derived
attributes.


Manage derived attributes

You can now add or remove derived attributes through the
Entity Repository Explorer’s context menu.


Manage user-defined references

You can also add or remove user-defined references through
the Entity Repository Explorer’s context menu.


Other resources

The Entity Repository Explorer now shows all other
resources that you create under the Datanect project. This gives
you a more flexible way to work with Datanect projcts.


Bug fixes
  • [DATANECT-201] – Support for LUW DB

Export


Bug fixes
  • [DATANECT-217] – Cyclic dependencies should be ignored
    if they are not contained in the export entity set.

What’s new in 2.0

Datanect 2.0 is a nearly complete new implementation based on Eclipse RCP. The goal is to provide a more stable application, more familiar user interface and better IDE integration in the future.


Framework


Datanect is now based upon the eclipse rich client platform. The old databrowser is integrated through a separate frame and a read-only view now.


Entity Repository Explorer


The entity repository explorer provides you access to all entity repositories and contained entities


Dynamic POJO Mapping generation

You can generate a hibernate dynamic pojo mapping from every RDBMS based entity repository now. This very helpful for rapid prototyp creation.


The context menu of the tablebrowser provides you all available commands.


Tablebrowser


A new tablebrowser was added that is now used to browse the data.


The context menu of the tablebrowser provides you all available commands.


Outline


The outline gives you a structured overview over the opened tablebrowsers.


 

Treebrowser


A treebrowser was added that allows you to support an entity related browsing. It is also very useful when you want to browse hierachical structures. Such as references to entities in the same table. E.g. child – parent relationships.


Export

The export is completely re-implemented and now supports consistent export data sets. it shows you inconsistent entities and provides you actions to add required entities or remove inconsistent ones.

 


Open in default editor
When an export is finished it will ask you if the exported file should be opened in the default editor.
This editor can be changed using Preferences -> General -> Editors -> File Associations.

 

What’s new in 1.3.1


Framework


License management

You can now directly open the license management dialog from a notification window. This will help you to install a new license more quickly.

What’s new in 1.3.0


Framework


Proxy settings

Support for network proxies was added in 1.3.0. The proxy settings will be used by nearly any component within datanect. The only exception is the driver browser, because it will be configured usind the maven settings file. So if you have network problems, e.g. when you want to activate your license, you should check the proxy settings first and try again.

 


Entity repository manager


Driver browser settings

You can now change the maven settings xml path that the driver browser uses.

 


Quick search support

You can now search the entity repository manager using the quick search support, either by pressing CTRL-F or just start typing. Navigate through the search hits using the arrow up and down keys or tab.

 


Entity browser desktop


Metadata browsing

You can now browse the metadata of an entity repository as well. This will give you a better overview of how your data is connected. It’s a useful feature even if you use another tool, e.g. an SQL based database tool, because you will need the metadata information to create e.g. SQL queries.

 


Self associations

The entity explorer does now allows self associations. This is an important feature when you need to browse data that is hierarchical connected.


Filters allow whitespaces

You can add more than one value to an entity filter by separating the values with spaces now. This will work for all number types like short, integer, double, BigDecimal, etc.


Bug fixes


Entity browser

  • DATANECT-169: InternalFrame’s resize cursor not shown on mouse over
  • DATANECT-167: Subsequent entity browser’s titles are misleadingly named [ROOT]

 

Planned for 1.3.0


Framework


  • Network proxy settings

Entity repository manager


  • Driver browser settings
  • Context menu

Entity browser desktop


  • Metadata browser

Entity browser


  • Allow self associations
  • BUG: Subsequent entity browser’s titles are misleadingly named [ROOT]

What’s new in 1.2.0


Entity repository manager


More well known drivers added to driver browser

JDTS driver added to the driver browser.


Entity browser desktop


Inter-repository browsing

You can now create instant associations between different data sources. This feature is helpful in distributed environments, e.g. in a microservice architecture. But it is also helpful when you want to connect data between different development stages, e.g. local developer database -> functional test database or integration database. See Help -> Help Contents -> Inter-Repository Browsing for details.


Association tool tips

Associations will show you a tool tips when you put the mouse cursor over them.


Bug fixes


Entity repository manager

  • DATANECT-121: UI freezes when using H2 database.
  • DATANECT-149: NPE in repository navigator on right click when no entity repository exists or is selected

Entity browser

  • DATANECT-124: NullPointerException when no primary key is available but CLOB column
  • DATANECT-125: JDBCType -155 is not a valid Types.java value
  • DATANECT-131: Unquoted column names in SQL Statement: BadSqlGrammarException
  • DATANECT-148: BusyIndicator holds focus
  • DATANECT-162: EntityBrowser load timeout