Thank you Bruno, I will contact you direct for more information about your component. Is it compatible with v16.R2 Windows Server/Client?
Kirk > On Jun 1, 2017, at 10:24 PM, Bruno LEGAY via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > Hi Kirk, > >> I have a large Oracle database from which I need to regularly extract >> specific data using a 4D application. Is there a preferred way to connect >> the two for data mining? ODBC, or ??? Anyone doing this with success and >> willing to share the connection architecture? Many thanks in advance... > > I will say it will depend.. > > It depends where you want to implement your business logic (Oracle side or 4D > side), > it depends on the volume of data you need to process (extracting a large > amount of data to summarize it into a small amount of data would be faster if > you do it on Oracle server side, no point moving data around in this case) > etc... > > To achieve the best performance/speed/flexibility, I would say 4D for OCI is > the way to go (but I may be biased ;-)). > It requires Oracle client libraries being installed on the client side and > the 4D for OCI plugin. > So if deploying the Oracle client libraries is not an issue for you this is > the way to go. > > OCI is a C API from Oracle (Oracle Call Interface). > 4D for OCI will give you access to the Oracle OCI API (and it will take care > of memory management and type conversion for you). > 4D for OCI coding can be a bit challenging at times. There is plenty of > documentation for the Oracle OCI api (with C code samples) and then you have > to apply that information to 4D for OCI. > > The Oracle client libraries are available on Mac OS X and Windows. > > <shamelessPlug> > We do sell a component to make 4D for OCI coding very simple and optimized > (as well as provide retrocompatibility with the old "4D for Oracle"). > Contact us privately if you are interested or if you need > help/coaching/training on 4D for OCI. > </shamelessPlug> > > For ODBC, you will also need to deploy Oracle client libraries AFAIK. > > > HTH > Bruno > > ********************************************************************** > 4D Internet Users Group (4D iNUG) > FAQ: http://lists.4d.com/faqnug.html > Archive: http://lists.4d.com/archives.html > Options: http://lists.4d.com/mailman/options/4d_tech > Unsub: mailto:4d_tech-unsubscr...@lists.4d.com > ********************************************************************** ********************************************************************** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **********************************************************************