Abas ERP Connector

Abas ERP Connector: Connects to the Abas ERP system via its JEDP interface and performs various operations.

Properties

Operation

Describes which operation the adapter performs.

Possible values:

Query: Query records and table contents
Info: Query metadata from abas
Write: Add or modify records and table contents

Parameter

Adapter	Main class of the adapter (do not change!) Possible values: de.softproject.integration.adapter.abas.AbasAdapter: Main Class (Standard)
appName	Name of the application Possible values: Any string
edpPort	EDP port Possible values: Any positive integer, e.g. `6550`
mandant	Name of the tenant Possible values: Any string, e.g. `systemtest`
host	IP address or host name of the IMAP server Possible values: Any valid string without protocol specification, e.g. `example.com`
password	Password for 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 the time limit is reached `NOWAIT`: Return the error immediately without waiting (default)
timeout	Time limit for establishing a connection 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)`	The Abas ERP system query timed out

Input

The adapter expects the following XML input structures for the various operations:

Operation: Query

XML

<Abas>
    <!-- Query ausführen -->
	<Query resulttag="...">
		<DatabaseGroup>00:01</DatabaseGroup>
		<Fields>
			<_ans/>
			<_str/>
			<_nummer/>
		</Fields>
		<Selection>nummer=20001!20002</Selection>
	</Query>
	<Query resulttag="...">
		<DatabaseGroup>01:01</DatabaseGroup>
		<Fields>
			<_schlag/>
			<_yvertragsnr/>
			<_kunde/>
		</Fields>
		<Selection>kunde=20001!20002</Selection>
	</Query>
</Abas>

Operation Info

XML

<Abas>
	<!-- Aktion ausführen -->
	<Info resulttag="...">
		<Nummer>1000</Nummer>
		<HeaderFields>
			<_bstart>1</_bstart>
		</HeaderFields>
		<TableFields>
			<_tysuch/>
			<_tyname/>
		</TableFields>
	</Info>
	<Info resulttag="...">
		<Nummer>1000</Nummer>
		<HeaderFields>
			<_bstart>1</_bstart>
		</HeaderFields>
		<TableFields>
			<_tysuch/>
		</TableFields>
	</Info>
</Abas>

Operation: Write

XML

<Abas>
    <!-- Bestehenden Datensatz ändern -->
	<Update resulttag="...">
		<Database>00</Database>
		<Group>01</Group>
		<Nummer>20001</Nummer>
		<HeaderFields>
			<_str>...</_str>
		</HeaderFields>
	</Update>
	<!-- Neuer Datensatz -->
	<Insert resulttag="...">
		<Database>00</Database>
		<Group>01</Group>
		<HeaderFields>
			<_nummer>200171</_nummer>
			<_such>Testsuch</_such>
			<_ans2>Testans</_ans2>
			<_str2>Testgasse</_str2>
			<_plz2>12345</_plz2>
			<_nort2>Testhausen</_nort2>
			<_zbed>100</_zbed>
		</HeaderFields>
	</Insert>
    <!-- Zeile in bestehendem Datensatz ändern -->
	<Update resulttag="...">
		<Database>71</Database>
		<Group>02</Group>
		<Nummer>4</Nummer>
		<Table>
			<Row nr="2">
				<TableFields>
					<_ytg02beschreibung>blau</_ytg02beschreibung>
				</TableFields>
			</Row>
		</Table>
	</Update>
	<!-- Neue Zeile in bestehendem Datensatz -->
	<Update resulttag="...">
		<Database>71</Database>
		<Group>02</Group>
		<Nummer>4</Nummer>
		<Table>
			<Row nr="2" new="true">
				<TableFields>
					<_ytg02beschreibung>gelb</_ytg02beschreibung>
				</TableFields>
			</Row>
		</Table>
	</Update>
</Abas>

Output

For the various operations, the adapter outputs the following XML result documents:

Operation: Query

XML

<Result>
	<Adresse>
    	<_ans>Max Mustermann</_ans>
    	<_str>Musterallee 2</_str>
    	<_nummer>20001</_nummer>
  	</Adresse>
  	<Adresse>
    	<_ans>Manfred Mustermann</_ans>
    	<_str>Testweg 1</_str>
    	<_nummer>20002</_nummer>
  	</Adresse>
  	<Vertrag>
    	<_schlag>RECHNUNG.2017.10</_schlag>
    	<_yvertragsnr>01-000001-001</_yvertragsnr>
    	<_kunde>123</_kunde>
  	</Vertrag>
   <!-- ggf. weitere Knoten -->
</Result>

Operation: Info

XML

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

Write Operation

XML

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

Dependencies

The connector uses the JEDP library of abas, jedp-3.3.5.jar.

The currently supported version is 3.3.5.

The library will not be delivered for licensing reasons. To use the library, copy it into the WildFly\modules\de\softproject\x4\extensions\main\ folder in the X4 Server installation folder, along with a module.xml file containing the following:

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>