Data Analysis perspective database setup

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

Before you start:
  1. In the Broker Application perspective, generate the DDL script:
    1. In the Data Project Explorer view, double click the .dbm file.
    2. Right-click the database name and select Generate DDL.
    3. 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.
    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 your database, create a JDBC connection so that the schema that is specified in the map is used. See データベースへの JDBC 接続の使用可能化.
  6. In the Data Analysis perspective, create a configurable service to enable access to your database. See 新しい構成可能サービスの作成.
特記事項 | 商標 | ダウンロード | ライブラリー | サポート | フィードバック

Copyright IBM Corporation 1999, 2013Copyright IBM Corporation 1999, 2013.

        
        最終更新
        
        最終更新 : 2013-02-27 19:23:08


タスク・トピックタスク・トピック | バージョン 8.0.0.2 | bd24253_