Overview of InfoSphere Data Click

IBM® InfoSphere® Data Click simplifies data movement and eases data placement. You can use InfoSphere Data Click to offload warehouse databases or offload select schemas and tables within warehouse databases.

You can use InfoSphere Data Click to retrieve data and work on that data in a test environment. You can move data from an operational database to a private sandbox. You can isolate the data to experiment with data transformations, or you can create reports from subsets of the data. By isolating and analyzing the data in a test environment, you do not jeopardize the integrity of the business information in the production environment.

InfoSphere Data Click relies on IBM InfoSphere DataStage® and can also use IBM InfoSphere Change Data Capture to provide efficient extraction, high throughput, and with minimum risk to your production system.

You can monitor offload requests by using IBM InfoSphere DataStage and QualityStage® Operations Console or the IBM InfoSphere Change Data Capture Management console. You can use IBM InfoSphere Information Server Web console to monitor and manage scheduled offload activity.

The user roles in InfoSphere Data Click are the administrator and the user. The role of the InfoSphere Data Click user is to submit offload requests. The user can modify offload requests based on the policies set by the administrator. The user might or might not be enabled to actually run an offload request. The InfoSphere Data Click administrator defines offload policies and user privileges.

The administrator completes set up of the InfoSphere Data Click environment. Set up activities include the following tasks: The administrator fulfills offload requests, if the user is not enabled to do so. The administrator also ensures that updates to source and target metadata are reflected in the InfoSphere Data Click environment.