Oracle DBlink

Is it possible to use the Oracle DBlink with appian DB?

  Discussion posts and replies are publicly visible

  • With our on-premise Appian install w/MSSQL back end, we have a DB link with an Oracle database.  Appian doesn't really have anything to do with linking at the DB level. 

    If I recall, the only issue we faced was having to utilize OPENQUERY as:

    SELECT * FROM OPENQUERY(LINKED_SERVER, 'SELECT * FROM YOUR_TABLE')

    The issue was that essentially which LINKED_SERVER you are accessing has to be hard coded in the view.  So, if you link dev/test/prod Oracle DBs from your dev/test/prod Appian instances, the VIEW code must be different in each server (annoying).

    We tested some stored procedure configurations, etc, but could not avoid that if I recall.

  • 0
    Certified Lead Developer
    in reply to Chris

    The DB layer of Appian supports only tables and views. Anything else is ignored. So as Chris mentioned you might need to wrap this into a view.