ER/Studio MetaWizard Does The Magic! Often times you would hear about moving objects from one Data Modeling platform to another for various reasons. Embarcadero's Meta-Wizard enables users of ER/Studio to achieve this Magic! Here is a sample Video showcasing a simple Export to IBM Cognos Framework Manager from ER/Studio. Also here is another video that showcases The Diagram view of the Logical and Physical Models being successfully imported. That's the power of Embarcadero's MetaWizard. Check out a Trial today at http://ww...

Posted by on in Cloud
Proof of Concepts made Easy with The Cloud As a Solutions Architect, there are times when you actually need to replicate customer scenarios, often becomes a challenge, unless you have your own data center to facilitate the same. Well thanks to the Cloud, Pre-Sales Engineers, Solutions Engineers and Architects can now use the cloud to implement Proof of Concepts in a simplified manner. This post will focus on two primary aspects relating to a PoC. 1) IaaS --> Infrastructure as a Service 2) DaaS --> Database as a Service   ...
Data Modeling for Agile Environments Agile Development has always been at the forefront of new ways of developing software. So why should Data Modeling be left behind? In this short post, we will cover some of the basic workings of an Enterprise Collaborative Data Modeling environment. In the next diagram, we shall see how a Data Model Lifecycle occurs in an Agile Environment For more information: Register for our Bi-weekly Demos here and learn how Embarcadero's ER/Studio can help you be more Agile!...
Integrated cross-platform SQL IDE for increased database development efficiency Have you ever wanted a SQL IDE that would help you code SQL for multiple platforms using a Single IDE? Now you can! with Embarcadero's RapidSQL XE6, it gives you the ability to code and debug SQL for some of the most demanding platforms like Microsoft SQL Server Oracle IBM DB2 SAP Sybase ASE MySQL JDBC ODBC and many more! We also have a Technical Preview of Teradata as well. Some of the key features! On-the-fly SQL syntax alerts, semantic validation, and SQL parsing Visual quer...

Posted by on in Database
Setting up InterBase in the Cloud with AWS Do you need a low cost, high performance embedded or workgroup database? Software developers select InterBase because it's easy to install, has a small footprint, requires no administration and is incredibly scalable and powerful. InterBase offers database and application development professionals high performance, scalable database technology essential to run business critical applications. Extensive security mechanisms protect data at rest, over-the-wire and in backups. InterBase is easily d...

Posted by on in Database Administration
Cloud Databases - A Primer Ever since the era of Cloud Computing featuring SaaS(Software as a Service) pioneered by Salesforce, Databases have not been left behind. Databases in the Cloud or Cloud Databases are being used synonymously. Cloud Database as defined by Wikipedia is "A cloud database is a database that typically runs on a cloud computing platform, such as Amazon EC2, GoGrid, Salesforce, Rackspace, and Microsoft Azure. There are two common deployment models: users can run databases on the cloud independently,...
Exploring Microsoft SQL Server System Databases The Microsoft SQL Server System comprises of four key System Databases master model msdb and tempdb The following table outlines the key points   System database Description master Database Records all the system-level information for an instance of SQL Server. msdb Database Is used by SQL Server Agent for scheduling alerts and jobs.  model Database Is used as the template for all databases created on the instance of SQL Serve...
Empower your Applications with Embarcadero Team Server APIs The Team Server REST Application Programming Interface (API) allows one application to talk to another application directly and securely. Team Server provides a way to connect your database tools to your data sources with a centralized glossary. You can define your business terms and other metadata, and your team can collaborate on the definitions. The Team Server REST Application Programming Interface (API) allows one application to talk to another application directly and securely. You can a...
Adhoc Database Monitoring Made Easy There are times when you need to get adhoc monitoring information from your databases. Well, now you can! with Embarcadero's DBArtisan Analyst Pack. The Analyst Pack, it comprises of three main components 1) Space Analyst 2) Capacity Analyst and 3) Performance Analyst For advanced space, capacity, and performance analysis and management, DBArtisan's optional Space, Capacity, and Performance Analyst components contain sophisticated diagnostics to help you pinpoint problems in yo...
Managing Change in Enterprise Data Modeling It is often said that Change Management is nothing new in the IT Industry. The Data Modeling space is no different. The critical facet in enabling smooth change management is utilization of Repositories that would talk to Data Modeling client. Then, being able to create versions that one can go back to in time. Think of it as a time machine that would allow one to back in the base version. With Embarcadero's ER/Studio Compare and Merge Wizard, you can achieve it with the Power of the Enter...

Check out more tips and tricks in this development video: