We are using native 4d sql and odbc works like a charm. On Mac we are using actual technologies oracle driver.
Regards Chuck ------------------------------------------------------------------------------------------------ Chuck Miller Voice: (617) 739-0306 Informed Solutions, Inc. Fax: (617) 232-1064 mailto:cjmiller<AT SIGN>informed-solutions.com Brookline, MA 02446 USA Registered 4D Developer Providers of 4D and Sybase connectivity http://www.informed-solutions.com ------------------------------------------------------------------------------------------------ This message and any attached documents contain information which may be confidential, subject to privilege or exempt from disclosure under applicable law. These materials are intended only for the use of the intended recipient. If you are not the intended recipient of this transmission, you are hereby notified that any distribution, disclosure, printing, copying, storage, modification or the taking of any action in reliance upon this transmission is strictly prohibited. Delivery of this message to any person other than the intended recipient shall not compromise or waive such confidentiality, privilege or exemption from disclosure as to this communication. > On Jun 2, 2017, at 1:05 PM, Benedict, Tom via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > Rooftop99 says: > > > >> 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? > > I only have experience connecting 4D with SQL Server, not Oracle, so there > may be some platform specific considerations, but I'm thinking you could > simply use 4D native SQL commands to connect and call a stored procedure in > Oracle. You would need to set up DSN on the client side for the Oracle > connection.. The extracted data would populate arrays in 4D. > > If the queries are ad hoc and need to change, you might better off with a > Oracle or SQL specific plugin, but if you aren't doing Inserts or Updates in > Oracle I think native 4D SQL should meet your needs. > > HTH, > > Tom Benedict > Optum > > This e-mail, including attachments, may include confidential and/or > proprietary information, and may be used only by the person or entity > to which it is addressed. If the reader of this e-mail is not the intended > recipient or his or her authorized agent, the reader is hereby notified > that any dissemination, distribution or copying of this e-mail is > prohibited. If you have received this e-mail in error, please notify the > sender by replying to this message and delete this e-mail immediately. > ********************************************************************** > 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 **********************************************************************