Before you start
In today's fast-paced world, information on demand plays a very critical role in business success. Hence, a stable database server that meets or exceeds expectations at the enterprise application level in the areas of performance, scalability, reliability, extensibility, maintainability has become a mandate. Informix Dynamic Server (IDS), a relational database server from the IBM Information Management products portfolio, meets these requirements with its copious feature set.
However, having the best database to support your application is not good enough considering the rampant growth of data coming from data-centric applications. This multi-fold growth in enterprise application data increases the load on the application database and also impacts performance. You may need to segregate older data and maintain it separately in such a way that it is easily accessible if needed for reporting or strategic decision making. IBM Optim solution provides functionalities such as archiving historical data from various database systems supporting the application, restoring data from these archives in the production environment, masking production data, and making it available for reliability and application quality testing
This tutorial gives you a quick overview of integrating Informix Dynamic Server with Optim Solutions and Optim Data Privacy Solution.
Informix Dynamic Server is a relational database management system designed to provide client/server processing capabilities for enterprises, workgroups, midsize businesses, and even small businesses. With its dynamic multi-threading architecture, IDS scales well and can manage very large volumes of data, providing high performance in the OLTP environment. With the new warehouse capabilities available in IDS, it can also be used in the analytics area to make smarter business decisions.
The high-availability data replication (HDR), the multi-node active cluster for high availability (MACH11) features, and other advanced features in the area of backup and restore make it a very resilient and highly reliable database server. Informix Dynamic Server is also well-known for its ease of use and low maintenance. With the Open Admin Tool, a PHP-based open source tool, and administrative SQL APIs, administration of IDS is minimal. Last but not the least, IDS is easy to manage. IDS provides enough flexibility and freedom to application developers since it supports a variety of environments, including Java™ technology, PHP, Ruby on Rails, and more.
However good the database system is, if there is no provision for separating old and inactive data from current, active application data, application performance will eventually deteriorate. This is where Optim plays a key role in enterprise data management—by providing the means for safe removal of historical data to an archive that can be stored in a variety of environments. It provides access to this data through multiple methods, such as report writers, ODBC/JDBC applications, and other types of applications.
In the future, if additional business processing is required, this data can be retrieved and placed back in the application environment. This archived data can even be viewed directly from the archive. Due to various regulatory and compliance restrictions, sensitive application data such as social security numbers or credit card numbers need to be masked before it is made available in the testing environment. Optim provides application-aware and persistent data masking routines that substitute realistic but fictional data in place of confidential fields for testing. Using Optim Test Data Management, a subset of production data can be separated out that can be further used in testing by loading or inserting it into the target environment.
In this tutorial:
- Learn how to configure Informix Dynamic Server to work together with Optim Solutions.
- Verify connections and set up sample tables and stored procedures.
This tutorial was written using the following software levels and assumes that you have them already installed:
- Informix Dynamic Server 11.50xC5
- Informix CSDK 3.50xC5
- Optim products:
- IBM Optim Data Growth Solution 7.1.1
- IBM Optim Test Data Management Solution 7.1.1
- IBM Optim Data Privacy Solution 7.1.1
In all the scenarios mentioned in this tutorial, the Informix CSDK must reside on the same machine with the Optim server, irrespective of where the IDS Server resides.
Note: The Optim documentation referred to in the tutorial is bundled with the Optim products and is not available on the Web.