Abas ERP Connector

Abas ERP Connector: Connects to a Abas ERP system via its jedp interface and executes different operations.

Properties

Operation

Defines the operation executed by the connector

Possible values:

Query: query data records and table contents
Info: query metadata from abas
Write: add or change data records and table contents

Parameter

Adapter	Main adapter class (do not change!) Possible values: de.softproject.integration.adapter.abas.AbasAdapter: Main class (Default)
appName	Application name Possible values: Any string
edpPort	EDP port Possible values: Any integer, e.g. `6550`
mandant	Client name Possible values: Any string, e.g. `systemtest`
host	Server IP address or Host name Possible values: Any valid string without protocol specification, e.g. `example.com`
password	Password for the authentication Possible values: Any string
edpVersion	EDP version Possible values: Any integer, e.g. `3.35` (default)
wait	Lock behavior of the session Possible values: `WAITINFINITE`: wait until lock is released `WAIT`: wait until lock is released or timeout is reached `NOWAIT`: return error instantly and without waiting (default)
timeout	Timeout value for the connection setup in seconds Possible values: Any integer, e.g. `30` (default)

Status Values

`1 (OK)`	The execution was successful
`-1 (ERROR)`	An error occurred during execution, e.g. due to an invalid XML input
`0 (TIMEOUT)`	A timeout occurred while querying the Abas server

Input

This adapter expects the following XML input structures for the different operations:

Operation: Query

XML

<Abas>
    <!-- Execute query -->
	<Query resulttag="...">
		<DatabaseGroup>00:01</DatabaseGroup>
		<Fields>
			<_addr/>
			<_str/>
			<_number/>
		</Fields>
		<Selection>number=20001!20002</Selection>
	</Query>
	<Query resulttag="...">
		<DatabaseGroup>01:01</DatabaseGroup>
		<Fields>
			<_schlag/>
			<_contractnumber/>
			<_client/>
		</Fields>
		<Selection>client=20001!20002</Selection>
	</Query>
</Abas>

Operation: Info

XML

<Abas>
	<!-- Execute action -->
	<Info resulttag="...">
		<Number>1000</Number>
		<HeaderFields>
			<_bstart>1</_bstart>
		</HeaderFields>
		<TableFields>
			<_tysearch/>
			<_tyname/>
		</TableFields>
	</Info>
	<Info resulttag="...">
		<Number>1000</Number>
		<HeaderFields>
			<_bstart>1</_bstart>
		</HeaderFields>
		<TableFields>
			<_tysearch/>
		</TableFields>
	</Info>
</Abas>

Operation: Write

XML

<Abas>
    <!-- Change existing dataset -->
	<Update resulttag="...">
		<Database>00</Database>
		<Group>01</Group>
		<Number>20001</Number>
		<HeaderFields>
			<_str>Test street</_str>
		</HeaderFields>
	</Update>
	<!-- New dataset -->
	<Insert resulttag="...">
		<Database>00</Database>
		<Group>01</Group>
		<HeaderFields>
			<_number>200171</_number>
			<_search>Test search</_search>
			<_addr2>Test addr</_addr2>
			<_str2>Test str</_str2>
			<_zipcode2>12345</_zipcode2>
			<_nort2>Testhausen</_nort2>
			<_zbed>100</_zbed>
		</HeaderFields>
	</Insert>
    <!-- Change line in existing dataset -->
	<Update resulttag="...">
		<Database>71</Database>
		<Group>02</Group>
		<Number>4</Number>
		<Table>
			<Row nr="2">
				<TableFields>
					<_ytg02description>blue</_ytg02description>
				</TableFields>
			</Row>
		</Table>
	</Update>
	<!-- New line in existing dataset -->
	<Update resulttag="Testupdate3">
		<Database>71</Database>
		<Group>02</Group>
		<Nummer>4</Nummer>
		<Table>
			<Row nr="2" new="true">
				<TableFields>
					<_ytg02description>yellow</_ytg02description>
				</TableFields>
			</Row>
		</Table>
	</Update>
</Abas>

Output

This adapter outputs the following XML result documents for the different operations:

Operation: Query

XML

<Result>
	<Address>
    	<_addr>Max Mustermann</_addr>
    	<_str>Musterallee 2</_str>
    	<_number>20001</_number>
  	</Address>
  	<Address>
    	<_adr>Manfred Mustermann</_adr>
    	<_str>Testweg 1</_str>
    	<_number>20002</_number>
  	</Address>
  	<Contract>
    	<_schlag>RECHNUNG.2017.10</_schlag>
    	<_ycontractnumber>01-000001-001</_ycontractnumber>
    	<_client>123</_client>
  	</Contract>
    <!-- More nodes -->
</Result>

Operation: Info

XML

<Result>
	<Test>
   		<_tysearch>XY123</_tysearch>
    	<_tyname>Test Abas-Server</_tyname>
  	</Test>
  	<Test2>
  		<_tysearch>XY123</_tysearch>
  	</Test2>
</Result>

Operation Write

XML

<Result>
	<Testupdate1>updated</Testupdate1>
  	<Testinsert1>inserted</Testinsert1>
  	<Testupdate2>updated</Testupdate2>
  	<Testupdate3>updated</Testupdate3>
</Result>

Dependencies

The connector uses library jedp by abas, jedp-3.3.5.jar

The currently supported version is 3.3.5.

The library is not delivered for licensing reasons. Copy the library file to X4 Server installation folder wildfly\modules\de\softproject\x4\extensions\main\ together with a file module.xml with the following contents:

module.xml

XML

<?xml version="1.0" encoding="UTF-8"?>
<module xmlns="urn:jboss:module:1.1" name="de.softproject.x4.extensions">
    <resources>
        <resource-root path="jedp-3.3.5.jar" />
    </resources>
</module>