Best way to perform third party app integration in version 4.6

[Former Member]

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?

[Former Member]

Hi Robert,

We have a very similar requirement... to call a stored procedure on Borque RAILTRAC system to get the Rail Freight Rate at the time of creating a Sales Order. Can you please give me more details on how you have implemented the call to the stored procedure and how the RFC connection is established? Thanks a lot.