Write to Database

 

Updated: May 13, 2016

Applies To: System Center 2012 SP1 - Orchestrator, System Center 2012 - Orchestrator, System Center 2012 R2 Orchestrator

The Write to Database activity writes a row into a database table. This activity interacts with the following databases:

  • Access

  • ODBC

  • Oracle

  • SQL Server

The Write to Database activity can be used to replicate important Windows Event Log Events to a database table that is able to be queried and maintained.

Before you configure the Write to Database activity, you need to determine the following:

  • The database you are connecting to.

  • The table and fields you are updating.

Use the following information to configure the Write to Database activity.

Details Tab

SettingsConfiguration Instructions
Table nameType the name of the database table that you are adding the row to.
DataThe list displays all the fields in the table that will be set. To add a field, click Add and enter the Field name and Value. To remove a field, select it and click Remove. To edit a field, double-click the field name.

Connection Tab

SettingsConfiguration Instructions
Database typeSelect the Database type from the drop-down list. The options include the following:

- Access
- ODBC
- Oracle
- SQL Server

Configuration instructions for each Connection tab Database type are listed in the following tables.

Access Connections Tab

SettingsConfiguration Instructions
FileType the name of the Access database file that you want to access.
Workgroup fileType the name of the Access workgroup file that is associated with this database.
User nameType the user name for the workgroup file.
PasswordType the password for the workgroup file.
DB passwordType the password for the Access database.

ODBC Connections Tab

SettingsConfiguration Instructions
DSNEnter the data source name.
User nameEnter the user name for this database.
PasswordEnter the password for this database.

Oracle Connections Tab

SettingsConfiguration Instructions
Service NameEnter the service name.
User nameEnter the user name for this database.
PasswordEnter the password for this database.

SQL Server Connections Tab

SettingsConfiguration Instructions
AuthenticationSelect either Windows Authentication or SQL Server Authentication.
ServerEnter the name of the SQL Server that you want to access.
Initial catalogEnter the name of the initial catalog.

If you selected the SQL Server Authentication option, type the user name and password used to access the SQL Server in the User name and Password boxes.

Timeout Tab

SettingsConfiguration Instructions
TimeoutEnter the amount of time that the Query Database activity will wait for the database operation to complete.

Set this value to 0 to wait indefinitely.

Security Credentials Tab

SettingsConfiguration Instructions
Use the security of the account assigned to the serviceSelect this option if you want to run the Query Database activity using the same account that the runbook server uses.
This accountUse this option to specify a different account. Enter the User name and Password. Note: If you specify an invalid user name or password, the account assigned to the runbook server will be used to run the activity.

Published Data

The following table lists the published data items.

ItemDescription
Initial CatalogThe initial catalog that was used when connecting to the database. This published data will only be available when SQL Server is selected on the Connection tab.
Database serverThe name of the database server. This published data will only be available when SQL Server is selected on the Connection tab.
Table nameThe name of the table that was written to.
Database userThe name of the user used to connect to the database server.
ODBC DSNThe name of the ODBC DSN. This published data will only be available when ODBC is selected on the Connection tab.
Oracle Service NameThe service name. This published data will only be available when Oracle is selected on the Connection tab.
Access fileThe Access database file that was modified. This published data will only be available when Access is selected on the Connection tab.
Access workgroup information fileThe Access workgroup file that is associated with the Access database file. This published data will only be available when Access is selected on the Connection tab.
Show: