Previous Next
Opalis Integration Server > Foundation Objects > Utilities > Write to Database

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:
Microsoft SQL Server
Oracle
Microsoft Access
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.
Common Published Data

Previous Next