Step 1: Creating the staging database
The first step to integrating data into the application database is to create a staging database. You might want to create a staging database in 规划管理控制台 for an existing application or for a new application.
The following list shows several reasons to create a staging database.
To start data integration by using a new staging database
To bring an existing staging database online after data cleansing
To replace the existing staging database
You must be a member of the Global Administrator role to create a staging database in 规划业务建模器 or 规划管理控制台, or by using the 规划命令实用工具. For more information, see Security roles.
- About the staging database
Discusses what the staging database is and how it is used.
- Create the staging database
Provides instructions on how to create a staging database for a new application in 规划业务建模器 and in 规划管理控制台.
- About the staging database after it is created
Provides information about the structure of the staging database after it is created in either 规划业务建模器 or 规划管理控制台.
- Attach or detach an existing staging database
Provides instructions about how to attach a staging database in 规划管理控制台.
- Connect to Planning Server for data integration
Provides instructions about how to connect to the Planning Server for data integration.