Configuring bulk insert

Typically, you use the bulk insert to facilitate fast data insertion into the database. If this mechanism is not enabled, data insertion can take significantly longer to process.

See how to configure the bulk insert feature:

To enable the bulk insert feature using the recommended configuration:

Microsoft SQL cluster

For Microsoft SQL clusters, execute all operations using the named instance of your cluster setup.

On the Microsoft SQL server, ensure that the NAM Server (old CAS) database user (delta by default) has the bulkadmin server role assigned. 
Use the Microsoft SQL Server Management Studio, go to Security > Logins, right-click the delta user, select Properties and go to Server Roles.

On the report server, ensure that the Central Analysis Server service is running under a common domain user account.

In Administrative Tools, select Services.

Right-click the Central Analysis Server service and open the service's Properties window. Click the Log On tab.

In the Log on as section, make sure that This account is selected and that the account name and password are correct and have administrative privileges.

Click OK.

Restart the service.

Right-click the service and select Restart.

On the database server, create and share a bulk insert folder.

Create the folder D:\bulkinsert and share it as a folder named bulkinsert with read and write permissions for the domain user that accesses remotely the database server  from the report server.

On the database server (MSSQL 2012), adjust the security rights of the BulkInsert folder

Right click, select properties

On the Security tab, Edit permissions.

In the Select Users, Computer, Service Account, or Groups dialog box, click Locations, at the top of the location list, select your computer name, and then click OK.

In the Enter the object names to select box, type the name of the service SID.  For the Database Engine per service SID, use NT SERVICE\MSSQLSERVER for a default instance, or NT SERVICE\MSSQL$InstanceName for a named instance.

Click Check Names to validate the entry. The validation often fails, and might advise you that the name was not found. When you click OK, a Multiple Names Found dialog box appears.

Now select the per-service SID, either MSSQLSERVER or NT SERVICE\MSSQL$InstanceName, and then click OK.

Click OK again to return to the Permissions dialog box.

In the Group or user names box, select the per-service SID, and then in the Permissions for <name> box, select the Allow check box for Full control.

Click Apply, and then click OK twice to exit.

On the report server, configure the bulk.write and bulk.read properties.

Open the report server Diagnostic Console by typing diagconsole in the browser's Address field: http://server_IP_address/diagconsole

Select General Properties Editor in the Configuration Management section and enter search value: bulk.read

Set the Value for bulk.read to D:\bulkinsert\
This is where the MS SQL database will go to get the data. If the database is not located on the same machine, enter a full network path. For example:
If the report server has an IP 192.168.1.25, and the database machine is 192.168.1.30, than you would enter the bulk.read value: \\192.168.1.30 \bulkinsert\\

Note

It is critical that you specify the full path, including the trailing slash as indicated here.

Set the Value for bulk.write to \\SQL_server_IP_address \bulkinsert\

Restart the report server.

In Administrative Tools, select Services.

Right-click the Central Analysis Server service and select Restart.