Set up your database so that you can use it with the Data
Analysis perspective.
- In the Broker Application perspective, generate the DDL
script:
- In the Data Project Explorer view, double click the .dbm file.
- Right-click the database name and select Generate
DDL.
- 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.
- 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
- If you are using Oracle, ensure that your schema name is
the same as your username.
- In your database configuration manager, run the SQL script.
- 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.
- In the Data Analysis perspective, create a configurable
service to enable access to your database. See Neuen konfigurierbaren Service erstellen.