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 Habilitación de conexiones JDBC con las bases de datos.
  6. In the Data Analysis perspective, create a configurable service to enable access to your database. See Creación de un nuevo servicio configurable.
Avisos | Marcas registradas | Descargas | Biblioteca | Soporte | Su opinión

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

        
        Última actualización
        
        Última actualización : 2013-02-27 18:27:15


Tema de tareaTema de tarea | Versión 8.0.0.2 | bd24253_