Oracle Bulk Import

Unknown

Oracle Bulk Import

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

[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/