Setting Up Your Data Mart Connection
You can follow the standard installation procedure,
and when the procedure is completed, your DBA needs to create a
database and connection for your server. For SQL Server and MySQL,
the PMF installer automatically creates the database schema and
all basic data structures required to run PMF. You only need to
follow these instructions if you need additional PMF databases for
testing or QA.
x
Procedure: How to Create a Database and Connection
-
Using the
SQL DDLs provided by Information Builders for your RDBMS, create
the structure of a production database.
-
In the WebFOCUS
Server Console, create a connection named pmf_system,
or modify an existing connection as needed.
-
Point the pmf_system adapter
connection to the new database.
-
Go to the
verification procedure described in Verifying an Installation or Upgrade.