Write to Database
The Write to Database object writes a
row into a database table. The Write to Database object interacts
with the following databases:
•
|
ODBC-compatible databases
|
Note: Opalis 6.2.2 disables native
MySQL support in the Query Database object and Write to Database
object. You will be required to change those objects to use ODBC if
you were using the native MySQL support prior to 6.2.2.
How it is used
The Write to Database object can be
used to replicate important Windows Event Log Events to a database
table that is able to be queried and maintained.
Configuration
To configure the Write to Database
object you will need to know the database that you are connecting
to as well as the table and fields that you will be updating.
Details Tab
Table name
|
Type the name of the database
table that you are adding the row to.
|
Data
|
The list displays all the fields
in the table that will be set. To add a field, click Add and type
the Field and Value. To remove a field, select it and click
Remove. To edit a field,
double-click it.
|
Connection Tab
Database type
|
Select the connection method
that will used to contact the database. Once you have selected your
Database type you will need to
configure the other connection information for that database. See
your database system documentation for information about connecting
to the database. If an Oracle database table or row is locked, the
Write to Database object will wait until it is unlocked before
attempting to insert the row.
|
Timeout Tab
Timeout
|
Specify the amount of time that
the Write to Database object will wait for the database operations
to complete. Set this value to 0 to wait indefinitely.
|
Available Published Data
Name
|
Description
|
Initial Catalog
|
The 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 server
|
The name of the database server.
This Published Data will only be available when SQL Server is selected on the Connection tab.
|
Table name
|
The name of the table that was
written to.
|
Database user
|
The name of the user used to
connect to the database server.
|
Oracle service name
|
The Oracle service name. This
Published Data will only be available when Oracle is selected on the Connection tab.
|
ODBC DSN
|
The name of the ODBC DSN. This
Published Data will only be available when ODBC is selected on the Connection tab.
|
Access file
|
The Access database file that
was modified. This Published Data will only be available when
Access is selected on the Connection tab.
|
Access workgroup information
file
|
The 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.
|