With round-trip database support, data modeling professionals can use ER/Studio Data Architect to easily reverse-engineer, compare and merge, and visually document data assets residing in diverse locations from data centers to mobile platforms. A variety of database platforms, including traditional RDBMS and big data technologies such as Hadoop Hive, can be imported and integrated into shared models and metadata definitions.
ER/Studio Data Architect includes the capability to capture data from Hadoop Hive tables into an entity relationship diagram with reverse engineering, as well as providing a means to create Hive tables and forward engineer them into a Hadoop Hive database. The integrated wizard menus allow the selection of specific tables and their properties to be manipulated, for granular visibility of the data.