Database Reference
In-Depth Information
Figure 8-19:
The script view output.
Data Importing and Exporting
Most analytics systems include some sort of external data. That data could be in the form of flat file
feeds from source systems, or it may be a replicated copy of a source system database. You should
carefully consider the data integration needs of your analytics system and work with your system
administrators to secure your data feeds.
An important and useful function of SQL Server is its ability to support data integration through SQL
Server Integration Services (SSIS). SSIS is a sophisticated and market-leading Extract Transform and
Load (ETL) tool. SSIS includes advanced features that allow you to manage complex data integration
requirements. In this section we cover some simple functionality to enable you to easily import and
export data from and to your SQL Server database. This is a simplified SSIS utility that is accessible
from the Microsoft SQL Server Management Studio and includes the ability to connect to multiple
types of sources and targets.
Search WWH ::
Custom Search