Import Data From a Database

You can import data by using the import tool to copy data from one database to another.

Each phase in the development lifecycle of your application uses an independent database for storing data. You can use the import tools in the Data Manager to import data from one database into another, for example, to import the data in your live database into your staging database.

To import data into a database:

1. Click the Options menu on the Business Objects page and select Data Manager.
2. Select the database that you want to update in the drop-down list at the top of the page.
   
   Description of the illustration bo-datamgr-seldb.png
   
   Unavailable databases are grayed out. After you select the database, the page will display the import and export tools for the database.
3. Click the tile to import data into your database.
   The page contains several import options. Unavailable options are grayed out.
4. Click Import in the Import Data dialog.
   All the data in the target database is deleted and replaced when you import data. When the task is complete, a dialog opens that confirms that the data was successfully imported or warns you that there was a problem.