Embarcadero makes data models searchable
August 22, 2008 —
When a government agency sought to remove what it thought was an offensive ethnic term from its approximately 60 data models, Embarcadero Technologies' new ER/Studio Enterprise Portal caught its eye. The company on Wednesday released this Web-based portal software for generating reports and scanning through huge data models for specifics.
In the case of the government's data models, the portal allowed developers and DBAs to find exactly which columns' names and descriptions needed to be changed. Previously, said Jason Tiret, Embarcadero’s director of modeling and design solutions, such a task might have been accomplished by pushing a data model into a SQL IDE and writing a long line of SQL code. But ER/Studio Enterprise Portal for the first time brings powerful search and reporting tools to this type of task in the company's popular ER/Studio data model repository.
“It's a Web portal on top of our ER/Studio repository. ER/Studio is our data modeling tool. ER stands for Entity Relationship. You use it to reverse engineer Oracle, MySQL, DB2 and Microsoft SQL Server databases. It would build a model for you, and you can put it in the repository. Multiple data modelers can work on these at the same time and put in definitions, or classify things by line of business. The portal is allowing other developers, DBAs and business analysts, to search that metadata,” said Tiret.
ER/Studio, said Tiret, “has been on the market since 1996. Now, based on popular demand, we've come out with this portal to help data architects publish models on the metadata and the models. They can take the portal and put their own reports into that. Anyone can log in and run reports and search the repositories. If a developer is working on a specific table and they see a column name, and they don't know what that means, they can open the portal and ask the definition and see the data type.”
ER/Studio Enterprise Portal is available now in packs of licenses ranging from five users to 50. Five users cost US$6,000, while 50 users cost $25,000.
The new portal also helps to keep reports based on data models up to date, said Tiret. “ER/Studio has a lot of reporting capabilities. You can dump things to an Excel spreadsheet or as HTML. The drawback is that they're static. They come out of the model. Once the model changes, you need to regenerate the reports. The portal really ensures everyone is coming to the single source of the truth.”
In the future, ER/Studio Enterprise Portal may add the ability to search through non-Embarcadero data model repositories, said Tiret. Until then, the company is focusing on tweaking usability and improving search functions.
Related Search Term(s): database management, Embarcadero
Share this link: http://sdt.bz/32759
Most Read Latest News Blog Resources
Android is the focus of two new design tools
Anywhere Software and Xamarin provide ways for developers to create and test their applications on PCs
|
|
LEADTOOLS HTML5 add-on modules released
Including New HTML5 Zero Footprint Viewer, JavaScript Libraries and RESTful Web Services for Document and Medical SDKs
|
|
How to speed up your Cukes
Using a five-step process derived from Six Sigma, Cucumber tests can go much faster
|
|
WhiteSource offers open-source license management as a service
Software gives companies insight into the open-source components in products
|
SmartBear rolls out new quality solution: API Complete
Software gives organizations ability to write test scripts and monitor APIs by bridging the DevOps divide
|
|
Android is the focus of two new design tools
Anywhere Software and Xamarin provide ways for developers to create and test their applications on PCs
|
|
WhiteSource offers open-source license management as a service
Software gives companies insight into the open-source components in products
|
|
Top five devices you can integrate with your applications
A five-fingered list of common, household items with which you can talk to (via software, of course)
|
Slick...but who needs it?
compilr.com is a well-designed site and the folks behind it seem to have their heart in the right place. But...who needs it?
|
|
How to be a better software developer
Want to be a better developer? You won't get there by mastering an interesting language or learning a new set of APIs.
|
|
Wooing Galatea
Do yourself a favor and check out Galatea 2.2, a wonderful book by novelist Richard Powers.
|
|
The world as story
An artificial-intelligence system at Carnegie Mellon seeks to understand the world by making statements about it.
|
Five SCM Best Practices
Two-thirds of all software projects fail, according to the Standish Group’s CHAOS study. Improper usage of software configuration management...
|
|
|
Best Practices for Branching and Merging Patterns
Development teams often create a branching pattern, usually drawn out on a white board or in a Visio document, that is used as a model to...
|
|
Automated Error Reporting
We invite you to read a short e-zine that tells you all about automated error reporting for .NET applications. This 8-page e-zine is packed...
|
|
The End of Application Redeploys
Imagine that every time you wanted to write, send or receive an email, you needed to restart your computer. How much time would this take, a...
|
Related Articles
Preflight builds spread wings for smoother projects
Developers are increasingly turning to preflight builds, allowing them to experiment with code before moving on to the full production build cycle. Electric Cloud and Urbancode already use them in their build management products.
|
Preflight builds spread wings for smoother projects
Developers are increasingly turning to preflight builds, allowing them to experiment with code before moving on to the full production build cycle. Electric Cloud and Urbancode already use them in their build management products.
|
Change Manager blends roles of DBAs, developers
Embarcadero's first post-acquisition version of CodeGear's Change Manager aims to combine the activities of developers and database administrators. It can hold numerous schemas in memory and examine the effects of changes on the whole database, among other abilities.
|