Oracle Bulk Import

Unknown
Unknown
in Flows
Oracle Bulk Import

Comments

  • Unknown
    Unknown

    We have put together a proof of concept for comparing various methods of importing data into SQL Server from Oracle. Currently we used a console app in c# using the Bulk Insert method of the System.sql namespace. Is this something that is exposed in Decisions that could be reused? Is it used by default when you add a table for the insert step?

  • Unknown
    Unknown

    [color=rgb(34, 34, 34)][font=Arial, Helvetica, sans-serif]For Oracle connectivity, Decisions uses the Oracle.ManagedDataAccess.dll but the Batch Insert step does not currently extend to support Oracle. [/font][/color]
    [color=rgb(34, 34, 34)][font=Arial, Helvetica, sans-serif]
    [/font][/color]
    [color=rgb(34, 34, 34)][font=Arial, Helvetica, sans-serif]If you would like to extend Decisions to add your bulk insert code you could do the following to add it: [/font][/color]
    [color=rgb(34, 34, 34)][font=Arial, Helvetica, sans-serif]
    [/font][/color]
    [color=rgb(34, 34, 34)][font=Arial, Helvetica, sans-serif]
    1. Put your code in a DLL that references the unmanaged Oracle driver and the Decisions SDK (so you can mark classes or methods as Decisions steps)
    2. Drop the unmanaged Oracle driver into the path where Decisions can find it.
    3. Copy your DLL into the ServicesDlls directory of the Decisions.Local module.
    [/font][/color]
    [color=rgb(34, 34, 34)][font=Arial, Helvetica, sans-serif]
    [/font][/color]
    https://documentation.decisions.com/deploying-server-side-extensions/

Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Sign In Register

Categories