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-Verbindungen zu den Datenbanken herstellen.
  6. In the Data Analysis perspective, create a configurable service to enable access to your database. See Neuen konfigurierbaren Service erstellen.
Bemerkungen | Marken | Downloads | Bibliothek | Support | Feedback

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

        
        Letzte Aktualisierung:
        
        Letzte Aktualisierung: 2013-02-27 15:24:06


TaskthemaTaskthema | Version 8.0.0.2 | bd24253_