Data Integrator interfacing with Java methods directly

[Former Member]

Currently we are using Java application to upload an excel file and then apply tons of validations against each row/cell in the spreadsheet before inserting into the database.

We are planning to use BusinessObjects "Data Integrator" to substitute this process.

So my question is rather creating these validations manually into Data Integrator, can we call Java methods directly from Data Integrator? If so can you please point out to some documentation or examples. This saves us months of development effort.

Thanks a lot in advance

[werner_daehn]

If that is an option, you could simply call the java program via the exec() function in a script before the dataflow.

Another option would be to encapsule your Java code into a DI Java Adapter either looking like a source table object or a function.

https://wiki.sdn.sap.com/wiki/display/BOBJ/Table+Source-Target

https://wiki.sdn.sap.com/wiki/display/BOBJ/FunctionCall

https://wiki.sdn.sap.com/wiki/display/BOBJ/AdapterSDKTutorial