You can call to the API by creating a custom task. Additional details and examples may be found under the topic Reading from a web service in DMExpress Help.
In regard to your first question, When specifying "add source", if SyncSort can execute a dynamic SQL so schema name won't be hard coded (in Oracle PL SQL we can use EXECUTE IMMEDIATELY for dynamic SQL) or execute a PL/SQL at run time?, th…"
Pearl River, NY
Your Title or Position
Customer Service Representative
Tell us about yourself, are you a ...