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