%META:TOPICPARENT{name="UDASystemIntegrationConfigDocs"}%

== Data Migration & Integration Configuration ==

===Configure MIcrosoft SQL Server DTS Import using the Microsoft OLE DB Provider===

Use the following instructions to configure a DTS Import.
# Open your **Microsoft SQL Server Enterprise Manager**.
# Drill down to **Console Root** >> **Microsoft SQL Servers** >> **SQL Server Group** >> **Your Actual SQL Server**
# Expand the **Security** folder.
# Right click on **Linked Servers**.
# Select "**New Linked Server**."
# Supply the following information on your General tab:
#* **Linked Server**: Any descriptive name (no spaces)
#* (Check the "**Other Data Source**" radio button)
#* **Provider Name**: **{{{Microsoft OLE DB Provider for ODBC Drivers}}}**
#* **Product Name**: **{{{MSDASQL}}}**
#* **Data Source**: Your ODBC Data Source Name
# Do not check any server options on the bottom of the tab.
# Provide your Data Source username and password on the **Security** tab.
# Click **OK** to create your server.
# Exit the Linked Server dialog box.
# Locate your newly created Linked Server.
# Expand the new Linked Server's tree menu.
# Click the **Tables** icon.
# Locate the **{{{qabasics}}}** table in the tables list.
# Carefully record the Schema and Catalog associated with the table. For example: 
{{{
Name       Schema   Catalog   Type
qabasics   dbo      master    User
}}}
# Expand the Microsoft SQL Server Enterprise Manager's **Tools** menu.
# Select the Microsoft SQL Server **Query Analyzer**.
# Build your query using the following guidelines: 
{{{
select * from [your linked server name].[catalog].[schema].qabasics 
}}}		
For example: 
{{{		
select * from SQL2KLA.master.dbo.qabasics 
}}}		
Note: Leave blanks in place holders when database lacks catalog or schema information. For example: 
{{{		
select * from ORA9iLA..SCOTT.qabasics 
}}}
#  Click the green arrow icon to run your query.