All posts by metadatadon

Covering all of Oracle's offerings for Data Integration e.g. real time data replication, bulk data movement and transformation, data quality, data wrangling, metadata management and Oracle's data recovery and high availability solutions. Working with emerging technologies such as Big Data and helping customers with on-premise, Cloud or hybrid deployment options. Oracle Data Integration Solutions is an exciting new software product stack at Oracle which allows our customers to ensure they are always using the Right Data in the Right Place at the Right Time. Data Integration Solutions help our customers to reduce the complexity, risk and cost of their IT operations while improving business intelligence and accelerating the time to market for new products & services, driving competitive advantage and top line growth. The Data Integration stack includes Oracle GoldenGate, for real-time, heterogeneous, change data capture, Oracle Data Integrator for high performance transformation and bulk data loading, Active Data Guard for Oracle HA/DR and Enterprise Data Quality tools. About Oracle: With more than 380,000 customers—including 100 of the Fortune 100—and with deployments across a wide variety of industries in more than 145 countries around the globe, Oracle offers an optimized and fully integrated stack of business hardware and software systems. Oracle engineers hardware and software to work together in the cloud and in your data center–from servers and storage, to database and middleware, through applications. Learn more about Oracle http://oracle.com/us/corporate DISCLAIMER: "The views expressed here are mine and do not necessarily reflect the views of Oracle."

Webinar: Make the Switch to ER/Studio

Tuesday, 03 February 2015

06.00 PST San Francisco
14.00 GMT London
15.00 CET Frankfurt / Paris / Milan

Register Now

Are you considering a switch from ERwin and want to understand what’s involved in a cost effective migration to ER/Studio rather than upgrading to ERwin 9.5?
Do you want to see how ER/Studio really works and get your questions answered before you make a decision?

Are you responsible for your organisation’s information strategy? Do you want to use a Data Modelling tool that promotes strategic planning and programme coordination? Do you want to avoid data quality related issues that delay project delivery or require costly unplanned rework late in a project and be able to provide unlimited browser access to model diagrams and metadata?

Join us for a live workshop and demonstration with ER/Studio Product Manager, Ron Huizenga. He will provide insights on topics such as:

  • Clear views of both logical and physical models in the intuitive ER/Studio user interface
  • Flexible and user-friendly features including Attachments, Naming Standards, and Compare and Merge operations
  • Capabilities such as Universal Mappings that ERwin doesn’t offer
  • Unlimited business user browser access to model diagrams and metadata
  • Steps to prepare for a successful data model migration
  • How to use the MetaWizard bridges to successfully import ERwin models

Bring your questions or send them in advance to mark.barringer@embarcadero.com and get them answered during the presentation.

Register Now

Ron Huizenga is the Product Manager for ER/Studio at Embarcadero. Ron has over 30 years of experience as an IT executive and consultant in Enterprise Data Architecture, Governance, Business Process Reengineering and Improvement, Program/Project Management, Software Development and Business Management. His experience spans multiple industries including manufacturing, supply chain, pipelines, natural resources, retail, health care, insurance and transportation. Before joining Embarcadero’s Product Management team, Ron Huizenga worked as an independent consultant for 20 years. He used both ERwin and ER/Studio with a wide range of customers and concluded that ER/Studio had the right features and capabilities to address the complex enterprise data architecture needs of his clients. Based on his personal experience, Ron is well positioned to host a “Switch to ER/Studio” workshop.

Advertisements

BigData Support: DBArtisan & RapidSQL Technology Preview

Recently I got the opportunity to have a tinker with our BigData Technology preview for DBArtisan and RapidSQL.

I was able to simply and easily register some of the BigData appliances I have installed, including, MapR, Hortonworks, Cloudera plus others.

BigData0One of the ways we have achieved this is by including the necessary JDBC drivers to connect to these platforms.

We support these platforms by going in via the Apache Hadoop Hive layer, and support Object Browsing and SQL querying through the support of HiveQL.

BigData1If anybody is interested in registering for the technology preview please contact us via the relevant support channels here.

MapRHortonworksCloudera    hadoopHive

Top 10 Reasons to Switch to ER/Studio

Before joining Embarcadero’s Product Management team, Ron Huizenga worked as an independent consultant for 20 years. He used both ERwin and ER/Studio with a wide range of customers and concluded that ER/Studio had the right features and capabilities to address the complex enterprise data architecture needs of his clients. Based on his personal experience, he explains the top ten reasons why he made the switch to ER/Studio, and addresses topics including:

  • Clear views of both logical and physical models in the intuitive ER/Studio user interface
  • Flexible and user-friendly features including Macros, Naming Standards, and Compare and Merge operations
  • Capabilities such as Universal Mappings that ERwin doesn’t offer

When:

Thursday, January 8, 2015
6:00am PST / 9:00am EST / 3:00pm CET
11:00am PST / 2:00pm EST / 8:00pm CET

Register Today

About the presenter:

Ron Huizenga is the lead Product Manager for ER/Studio at Embarcadero. Ron has over 30 years of experience as an IT executive and consultant in Enterprise Data Architecture, Governance, Business Process Re-engineering and Improvement, Program/Project Management, Software Development and Business Management. His experience spans multiple industries including manufacturing, supply chain, pipelines, natural resources, retail, health care, insurance and transportation.

Don’t just model! Publish, share and integrate.

The ER/Studio Team Server REST Application Programming Interface (API) allows one application to talk to another application directly and securely.

ER/Studio Team Server provides a way to connect your database tools to your data sources with a centralized repository. You can define your business glossaries as well as business terms and relate to the technical metadata thus allowing your team to better understand and collaborate around business definitions.

You can align system data with business-critical data, and easily update the database models stored in ER/Studio Team Server’s Repository with the API features such as GET, POST, PUT, and DELETE commands through the user-friendly interface.

To learn more about ER/Studio Enterprise Team Edition please click here

Further details on the API reference can be found here here

Do you know your data? Where it’s come from? Where it’s going? How it’s derived?

Graphically understand and interactively explore your Data Lineage

Data Lineage for ER/Studio gives data management professionals and business users essential insight to the extracts, transformations, and loads of complex enterprise data. Data governance and organizational compliance is supported with detailed metadata management for risk reduction and data discrepancy isolation.

In this presentation we look at the key reasons for using ER/Studio Data Lineage and what it provides you with.

To learn more about ER/Studio Data Lineage please look here: http://www.embarcadero.com/products/er-studio-data-lineage or request a demo here: http://forms.embarcadero.com/forms/ERStudioProductInterest

Want something more feature rich than the UISQL editor included in ER/Studio?

Well you can by changing the option in Tools | Options | Tools within ER/Studio and point it to Rapid SQL:

Tools Options Tools

Now any time either of the application wizards generate any SQL code (i.e. compare and merge, generate database), the code will launch in Rapid SQL.

Rapid SQL code

Find out more about Rapid SQL here: http://www.embarcadero.com/products/rapid-sql

Watch this video on Data Lineage by Torquil Harkness

When you can trust your data through its data lineage, you can create compliance reports with confidence, reduce the risks of untraceable data, and more quickly identify and isolate data errors, ultimately saving time and effort in your data management. ER/Studio is designed to help you organize, structure and model your data from multiple different sources, both relational and unstructured.