Best way to perform third party app integration in version 4.6
I am working with a third-party vendor offering a freight and transportation rate software (Bourque Rateserver and Railtrac).
From our 4.6 system, we need to perform relatively simple remote SQL statements (inserts, call stored procs, reads). We attempted to code these operations with EXEC SQL abap statements, but ran into permissions problems on the remote system. We do not want to deploy middleware (XI, other EAI tools). Can anyone provide thought on the best way to develop this simple integration?