The following parameters are supported for the DB Outbound Endpoint:
Parameter |
Value |
Required |
|---|---|---|
Name |
Name of the Service Endpoint. |
X |
Type |
Type of the Service Endpoint. The value is preset with “DB Outbound” and cannot be changed. |
X |
Description |
Description of the Service Endpoint. |
|
Table Name |
url-String: Oracle: jdbc:oracle:thin:@dbserver:1521:sde10 Access: jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=D:\\Test.mdb |
X |
URL |
Database Connection URL format: Oracle with SID: jdbc:oracle:thin:@hostname:port:SID Oracle with Servicename: jdbc:oracle:thin:@//hostname:port/servicename PostgreSQL: jdbc:postgresql://hostname:port/databasename MS SQLServer: jdbc:sqlserver://hostname:portnumber;database=databasename SAP HANA: jdbc:sap://hostname:port |
X |
Driver |
Database password for login. |
X |
Table Owner |
XSL file, in which the assignments between incoming data and the VertiGIS Integrator is defined in a temporary XML file. |
X |
Username |
Oracle: oracle.jdbc.driver.OracleDriver Access: sun.jdbc.odbc.JdbcOdbcDriver |
X |
Password |
Table owner. |
X |
XSL Parameter |
Table to be read. |
|
Request XSL file |
The UT XML is transformed into outgoing XML to create/update/delete rows in the database table. |
X |
Response XSL file |
The response XML is transformed into UT XML in order to process the data. In case of the File Outbound Endpoint the response XML is identical to the request XML. . |
|
The database Outbound Endpoint processes the following XML format to insert/update/delete rows in the database table:
Insert rows:
To insert rows:
<DBROWS>
<DBROW>
<ATTRIBUTE name="ColName1" type="ColType1" value="ColValue1" />
<ATTRIBUTE name="ColName2" type="ColType2" value="ColValue2" />
...
</DBROW>
</DBROWS>
Example:
<DBROWS>
<DBROW>
<ATTRIBUTE name="BUILDING_DATE" type="DATE" value="2017-09-27 15:58:16" />
<ATTRIBUTE name="TYPE" type="VARCHAR2" value="Station" />
</DBROW>
</DBROWS>
Update Rows:
To update rows:
<DBROWS>
<DBROW>
<WHERE>Condition</WHERE>
<ATTRIBUTE name="ColName1" type="ColType1" value="ColValue1" />
<ATTRIBUTE name="ColName2" type="ColType2" value="ColValue2" />
...
</DBROW>
</DBROWS>
<DBROWS>
<DBROW>
<WHERE>TYPE='Station'</WHERE>
<ATTRIBUTE name="BUILDING_DATE" type="DATE" value="2017-09-27 15:58:16" />
<ATTRIBUTE name="TYPE" type="VARCHAR2" value="MV Station" />
</DBROW>
</DBROWS>
Delete Rows:
To delete rows:
<DBROWS>
<DBROW>
<WHERE>Condition</WHERE>
<DELETE/>
</DBROW>
<DBROWS>
<DBROWS>
<DBROW>
<WHERE>TYPE='Station'</WHERE>
<DELETE/>
</DBROW>
<DBROWS>
Example:
<DBROWS>
<DBROW>
<WHERE>TYPE='Station'</WHERE>
<DELETE/>
</DBROW>
<DBROWS>
Delete all Rows in table:
To delete all rows in a table:
<DBROWS>
<DELETE_ALL_ROWS/>
<DBROWS>
<DBROWS>
<DELETE_ALL_ROWS/>
<DBROWS>
Example:
<DBROWS>
<DELETE_ALL_ROWS/>
<DBROWS>
