WebSphere Message Broker, Version 8.0.0.7 Operating Systems: AIX, HP-Itanium, Linux, Solaris, Windows, z/OS

See information about the latest product version

Data Analysis database setup

Set up your database so that you can use it with Data Analysis.

Before you start:
  1. In the Broker Application Development perspective, generate the DDL script:
    1. In the Project Explorer view, expand the project folder.
    2. In the Data Models folder, expand the .dbm file.
    3. Right-click the database name and select Generate DDL.
    4. To configure the DDL script, follow the steps in the Generate DDL wizard and click Finish.
    • Your SQL script is generated. This script shows the commands that are used to create your database tables.
    • The 'DOCID' column is added to your database. At runtime this column is populated with a unique string, to provide a map with a unique input key for database operations. Alternatively, you can set the input key yourself, by setting
      LocalEnvironment.Database.Input.Key
      in your local environment.
    • The 'ID' column is added to your database. The 'ID' is the foreign key that links related tables together.
    Tip: If you do not have a .dbm file, open the Generate Data Analysis Tools wizard and check the Insert transformed messages into database box.
  2. If you are configuring a Microsoft SQL Server 2008, above the Create Schema line in your SQL script insert DROP SCHEMA "SCHEMA_NAME" GO. For example:
    DROP SCHEMA "MYSCHEMA"
    	GO
    
    	CREATE SCHEMA "MYSCHEMA"
    	GO
    
    	CREATE TABLE "MYSCHEMA"."MYTABLE" (
    		"COLUMN1" VARCHAR(1000) NOT NULL,
    		"COLUMN2" INT NULL
    	)
    	GO
  3. If you are using Oracle, ensure that your schema name is the same as your username.
  4. In your database configuration manager, run the SQL script.
  5. In WebSphere® MQ, create a JDBC connection so that the schema that is specified in the map is used. See Enabling JDBC connections to the databases.
Notices | Trademarks | Downloads | Library | Support | Feedback

Copyright IBM Corporation 1999, 2016Copyright IBM Corporation 1999, 2016.

        
        Last updated:
        
        Last updated: 2016-05-23 14:48:02


Task topicTask topic | Version 8.0.0.7 | bd24253_