Recently, the Competence Center Corporate Data Quality (CC CDQ, a European consortium research program) engaged with Fraunhofer Institute for Material Flow and Logistics to produce a new Market Study report called METADATA MANAGEMENT TOOLS FOR ENTERPRISE DATA MANAGEMENT. This extensive market study describes the role of data management in today’s enterprise and provides a broad overview of over 30 software solutions available, including Embarcadero’s ER/Studio XE7. Embarcadero is honore...

This is an excerpt from the IDC Technology Spotlight June 2015 report, Enabling Enterprise Agility Through Model-Driven Data Design. This paper examines the growing importance of model-driven processes for database design and management. You can download the entire report here.

In the webinar, Demystifying Macros with ER/Studio, Embarcadero Software Consultant Stanley Chan demonstrated how macros work in ER/Studio. He showed how to use the built-in macros and also shared some custom macros during the session. If you missed the live presentation, you can watch it on demand. There were a lot of great questions during the session, some of which Stan didn’t have time to answer live. So he has provided responses to several of those for this blog. Q: In the color-coding de...

In my last post, I suggested that the conventional “facet” approach to designing master data models (in which each master domain is modeled, designed, and implemented in isolation from the others in the enterprise) creates gaps in the ability to effectively build applications that facilitate successful execution of end-to-end business processes. For example, the perception (and consequently the definition) of the role of a “customer” changes between the marketing, sales, finance, fulfillment, an...

On April 28, 2015, Embarcadero announced the XE7 release of our award-winning ER/Studio data modeling and architecture suite, with new features to improve agility and collaboration in enterprise data landscapes. Let’s highlight them, and for more details and a demonstration, you can watch the on-demand webinar from April 30th. ER/Studio continues to incorporate new capabilities and features to improve the user experience, enhance the data architecture, and address emerging industry technologies...

Anthem Inc. – 80,000,000 records stolen; Sony Pictures – 100 terabytes of data stolen; JP Morgan Chase – 70,000,000 records stolen; and EBay – 145,000,000 records stolen. This short list is the “tip of the iceberg” of organizations across all industries that have had significant amounts of their customer, employee, and other important organization data stolen. With the increased reliance of digital information by organizations and their customers, these trends will likely continue and be fueled ...

Sometimes you need to face the inevitable: the tool selected years ago is not the one you need for the future. Have you been struggling with complicated modeling tasks or outdated tools? Are your data models getting too big to handle? We’ve heard from a lot of customers recently who have been frustrated with their old data modeling tools, for multiple reasons such as: Lack of functionality Lack of support Lack of a future roadmap Embarcadero is committed to enabling our users to adapt to...

This is the third post in this series. Read the previous post. In my last post, the discussion focused on the ability to infer metadata about data sources to be ingested into the enterprise for which there is little (or no) provided metadata. Yet the topic of our discussion is not purely ingestion of data into the enterprise, but integration of that data. So presuming that we were able to assemble a comprehensive view of the metadata for the data sets to be brought into the organization, w...

This is the first post in this series. Read the next post. The continued fascination with expanding an organization’s analytics capabilities often centers on the desire to identify interesting and new data sources originating outside the enterprise that can be integrated into a big data analytics application. The presumed wealth of information hidden within third-party or otherwise externally-sourced data sets has inspired many aspiring data scientists to rapidly create processes for accessing ...

Over the years, I've had a number of occasions to need to store information about when somebody worked on a certain job. Sometimes people will want to store the date the work was done and the number of hours the employee worked, where as other people will need to store the start time and the stop time (in other words, when the employee "punched in," and when the employee "punched out"). Often, the same customer will need to use both methods of recording time, depending upon the nature of the wor...