Embarcadero Technologies has an update of its database tools – ER/Studio, DBArtisan, Rapid SQL, DB Optimizer and DB Change Manager XE5 — that among its new features includes integration with its Connect metadata governance repository. Connect, which The Semantic Web Blog covered here, keeps all the information about an enterprise’s data — what it means and where it is – to bridge the gap between the work of governance teams and that of day-to-day operations.
“We are providing terrific metadata integration right in the product,” says Henry Olson, director of product management. It is effectively the first instance of collaboration, syndication and integration across ER/Studio, Embarcadero’s data architecture and modeling tools, DB PowerStudio database development, administration, and performance tuning solutions, and Connect. “That’s a deep theme for us because it is a perennial problem in large organizations to make the work of the data architect team more broadly available,” he says, “and to make others more aware of the data assets and better able to use them.”
As users work within DB PowerStudio, for example, they get insight and pop-ups for all the data elements so that they understand exactly what each one means, he says. The technology works much like a spell check to bring up highlights as users are working with queries to tell them there is more information there to explore.
As Olson explains it, that seamless integration comes in handy in situations like this one: A global human resources database might include annual salary data elements in Euros. But if that’s not clear to someone working with the information for the yearly budget review, serious errors can be made in analyzing and presenting data. With XE5, users also will get alerts regarding sensitive data. If a data element has to be masked for non-production use, for example, that will be flagged. That prevents violations in policy, where, for example, customer data might wind up on an employees’ laptop, “set free on the subway,” Olson says.
“A lot of people think the job of data quality is done when you write the right data to disk, but in reality it’s when the data is properly interpreted and used,” he says. “So this integration gives you a big leg up in terms of productivity and quality.”
Finally customers are understanding they need to deploy cross-functional teams to get the best use of their information assets, Olson says, and capabilities like this are in support of that. Users’ challenges in getting the most out of their data are only going to grow as data volume, velocity and variety increase. “There’s more data to manage, less that can be well-understood and more of it that represents a potential risk if misused,” he explains.
The XE5 release also features in ER/Studio extended support for the Teradata enterprise data warehouses, enabling data professionals to better manage their data warehouses from logical and physical models, the company says. The new tools bring proprietary scale and data warehouse capabilities to Teradata customers who need to use Multi-Level Partitioned Primary Indexes and temporal data types. Rapid SQL XE5, a tool for cross-platform SQL development and debugging, and DBArtisan XE5, a tool for cross-platform administration and management, are enhanced to include support for Oracle 12c, SQL Server 2012, Sybase ASE 15.7 and IBM DB2 z/OS 10 and LUW 10. Both tools also now provide native 64-bit operating system support and new Windows 8 support.