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 **********************************************************************