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
Zeichick’s Take: Radio moves from analog waveforms to digital packets
Streaming radio highlights the need for streaming applications to be designed to take up as little bandwidth as possible
|
|
Taking enterprise architecture to the business side
Startup Corso is bringing out a cloud-based planning platform that ties into business plans
|
|
Appcelerator Acquires Cocoafish to Add Instant Mobile Cloud Capabilities to its Industry Leading Titanium Platform
Appcelerator Offers Messaging, Social, Location and Storage Mobile Cloud Services to All Mobile App Publishers
|
|
ComponentOne Releases a Collection of 40+ UI Widgets Powered by HTML5 and jQuery
ComponentOne has announced the 2012 release of Wijmo: a kit of UI widgets for HTML5 and jQuery development
|
Taking enterprise architecture to the business side
Startup Corso is bringing out a cloud-based planning platform that ties into business plans
|
|
Top five apps to manage your workload
Web applications offer new ways to track your “to-do” lists
|
|
Not so fast when it comes to testing in the cloud
Developers face outsourcing, virtual lab management and mobile devices as obstacles
|
|
Xceed releases UX-focused suite for Microsoft’s WPF
"Blendables" helps match user experiences to developer visions
|
Are you at risk for burnout?
Burnout is a severe problem and it can strike at any time. Here's how to tell if you are nearing the edge.
|
|
Agility, mom, and apple pie
If we're to evaluate the state-of-the-art in software development, we should start with the values espoused in the Agile Manifesto.
|
|
RIM woos developers with free tablet
How do you get more apps ported to the BlackBerry PlayBook? By giving every developer a free tablet, of course!
|
|
GitHire: Use Headhunters to Find Your Perfect Programmer
Are you a hiring manager tired of scouring the job boards? Check out this new service that will find 5 people interested in your jobs.
|
The Hidden Costs of Software Licensing
Moving beyond paper-based software licensing to more flexible, software-based licensing is a business decision. There is a growing trend tow...
|
|
Case Study: You May Need a Development Mechanic
As a contractor for a major financial player in Germany, SOBEGE, a German-based consultancy specializing in embedded IT and web services, wa...
|
|
Ensuring Software Quality at a Major International Bank
One of the world’s leading international banks has adopted AgitarOne technology for delivering generated unit tests for their Java software...
|
|
Load Testing Adobe Flex Applications
Adobe Flex applications may be different from applications you’ve worked with before. For classic HTML web applications, the server does all...
|
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.
|