You are viewing limited content. For full access, please sign in.

Question

Question

Connecting WF data activities to Oracle?

Workflow
Updated December 16, 2014
asked on December 16, 2014

Hi,

I need to connect the workflow "update data" activity to an oracle table.  I'm just wondering how I should go about doing this.  Of the 3 options, Direct, ODBC, and Expert, which one is best, and are there any special considerations?  Unfortunately I don't have an Oracle test server, so I'll need to configure this in the client's live environment.

Thanks,

Eric

0 0

Answer

SELECTED ANSWER
replied on December 16, 2014

You need to install Oracle Client 11.2.0.2.1 or higher with the corresponding version of Oracle Data Access Components (ODAC) on the Workflow Server. The CPU architecture of the Oracle Client should match the Workflow Server as well (x64 if WF is x64, x86 if Workflow is x86).

ODBC with a System DSN should be the easiest to configure.

1 0
replied on December 16, 2014

Thanks!

0 0

Replies

You are not allowed to reply in this post.
You are not allowed to follow up in this post.

Sign in to reply to this post.

Details
Related Posts
Loading ...