Import data directly from the Analysis machine

If you are using an SQL server to store Analysis result data, you can configure Analysis to import data directly from the Analysis machine.

In this topic:

Import data from the SQL server

If you do not select the option to import data directly from the Analysis machine, Analysis creates CSV files in a local temp folder. The CSV files are copied to a shared folder on the SQL Server machine. The SQL server engine then imports the CSV files into the database. The following diagram illustrates the data flow:

Back to top

Import data from the Analysis machine

If you selected the option to import data directly from the Analysis machine, Analysis creates the CSV files in a shared folder on the Analysis machine and the SQL server imports these CSV files from the Analysis machine directly into the database. The following diagram illustrates the data flow:

Back to top