1. In a workspace, you can write data from either any Statistica spreadsheet or any existing Enterprise data configuration to an external database. For instance, in this example, a Statistica spreadsheet "Adstudy" and an Enterprise data configuration "Example_Adstudy_2" in the workspace will be written back to external database.

2. Click the data source to highlight the input data that needs be written back, and then click Data Mining|"Write to Database" to insert "Write Spreadsheet to Database" node to the workspace.

3. Click the wheel icon on top left(circled in red) of the node to edit parameters.

3. Put the mouse in the blank to see the floating text explaining each entry.

For database connection, you can enter it as an Enterprise Database Connection Object name or an OLEDB connection string.

In the below example of an Enterprise Database Connection, either the Name or the Connection String can be entered in as the "Database Connection":

In the case of "Connection string", the Provider and other parameters will differ slightly based on the database the user is connecting to. For example, tha above one is for SQL server. The below example will connect to Oracle database.

Provider=OraOLEDB.Oracle.1;Password=*****;Persist Security Info=True;User ID=HR;Data Source=Oracle10;

If you don't have the database connection yet, the easiest way to create a connection string is to using the data link properties dialog when creating a database connection or using File| External Data | Query Builder and then get the connection string ( refer to step 7 of KB).

For instance:

4. Enter other parameters and select appropriate options to finish editing the Write to database node, Click "OK".

5. Click the green arrow icon on bottom left to run the node and the data will be written back to the specified database.