Jump to content
View in the app

A better way to browse. Learn more.
FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

oracle connection to filemaker

bzzzz
in External Data Sources

Featured Replies

we have a filemaker pro server and some of the data needs to be imported weekly into an oracle database.

my understanding is this can be done and it is roughed out in the "FileMaker 7 ODBC and JDBC Developer's Guide"...available here if anyone is interested:

FileMaker Documentation

however, i know nothing about oracle, but i don't need to since there are people on staff to deal with that. i am presenting this connection option as the best way for the oracle guys here to get the data they need. the other option is for them (non-filemaker savvy people) doing exports and importing them into oracle. they don't want to do this because they don't like filemaker. i believe this whole process would be easier if i keep the oracle guys in what they know and love, oracle. once the extract was properly set up it could be done as cron job. all done.

so my question is, how would one accomplish this?

broad strokes that i could give to the oracle people to direct them.

i figure they could build a small custom app to do this, but i have no idea what is involved with that. or, perhaps the oracle application has the ability to run scripts?

any pointers would be helpful.

thanks!

  • 2 weeks later...
  • Newbies

Hi,

I'm just starting out on a process to do something similar to what you want to do (I think)... except I need to go back and forth between FM and Oracle. I would recommend two options for you to look at:

1) Create a FM script to export the information to a comma-delimited file(s), which can then be easily imported into the appropriate Oracle table(s).

2) A more complicated route (theoretical at this point...I haven't accomplished this yet) would be to get FM talking to the Oracle DB directly through a driver such as http://www.actualtechnologies.com/ sells. This enables FM to connect through ODBC to the Oracle DB. Then use "Execute SQL script step" to create SQL statements to actually insert/update records directly into the Oracle DB. Note this can be dangerous to do because it writes directly to the Oracle tables, bypassing any DB logic that may be there (i.e. file locking, validation, indexes, etc.)

I'd be interested in how this process works for you...maybe we can share info about this. My email is [email protected].

Cheers.

Create an account or sign in to comment

https://fmforums.com/topic/39211-oracle-connection-to-filemaker/
Go to topic listing

Important Information

By using this site, you agree to our Terms of Use.

I accept

Configure browser push notifications
Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.