database OCI, Enterprise, CLI, Load, Load Express

tostay2003 · Post by **tostay2003** » Wed Jun 17, 2009 12:10 pm

Hi,

For almost every database plugin we have OCI, Enterprise, CLI, Load, Load Express.

What are the differences between these stages. i.e. when to use them?

Load Express - This appears as a direct load in SQL loader. Am I right?

Thanks

mandyli · Post by **mandyli** » Wed Jun 17, 2009 12:23 pm

Yes. You are right..

All the plug-in stage needs to use depend upon your requirements.

Better to use all native Enterprise stage is always good.

tostay2003 · Post by **tostay2003** » Wed Jun 17, 2009 12:32 pm

mandyli wrote:Yes. You are right..

All the plug-in stage needs to use depend upon your requirements.

Better to use all native Enterprise stage is always good.

what are the others used for i.e. the oci, cli stages and again when to use load vs load express stage

chulett · Post by **chulett** » Wed Jun 17, 2009 1:00 pm

Those are going to be database specific stages, typically tied to the interface they are named after. OCI = Oracle Call Interface, CLI is for Informix and any 'Load' stage is usually a bulk load of some kind.

ray.wurlod · Post by **ray.wurlod** » Wed Jun 17, 2009 4:24 pm

Then, when you get to version 8, you will also have Connectors in the mix.