Import from SQL Server and Oracle

Use the Import from SQL Server/Oracle import type to import data from another SQL/Oracle server.

To import data from another SQL Server/Oracle:

1. Enter a name for the Import Mapping in the Name field.
2. In the Import Type field, select Sql Server or Oracle from the dropdown list.
3. Click the ... button to the right of the Connection String field.
4. In the Connection String dialog box, Enter the names of the server and database for the database from which you want to import data in the Server and Database fields, respectively.
5. Enter the username and password in the Username and Password fields, respectively.
   Note: The steps for importing data from Oracle is the same, except that the Connection String dialog box looks slightly different.
6. Click Save.
7. Click Add to add a mapping.
8. In the Source Table Name - SqlServer field, select the table you want to import the data from.
9. Click the ... button next to the Destination Entity Name field to browse to see which tables are available in the external database, then choose the table from which you want to import the data.
   When you have chosen the table, the view displays the suggested mapping.
10. Click Save when you are done defining the mapping.