INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Oracle to 4D

Oracle to 4D

(OP)
Does anyone here know how to extract data FROM a 4D database to Oracle.

Ideally, I would like to set up an ODBC or ORACLE Link directly to the 4D database and use regular Oracle gateway SQL to pull data from 4D.

I also have mainframe DB2 available or for that matter mainframe Oracle.

Any suggestions would be helpful.

Based on my reading, 4d is not very open about how their product works and seems to hold the data for ransom.

Thanks in advance for any response.

Domingas

RE: Oracle to 4D

Use the ODBC for 4D Server product.

No, it is not the best, but it sure beats table exports from 4D.

I have been spending that last three/four days trying to access my 4D data for a MS SQL Server application.  It works fine, if the server app running is a new version (2003.1); however, I cannot get it to work in an older server version (6.0.5/6.0.6).

Download the driver from 4D.com.  Installation is straight-forward.  DSN setup is minor.

Connectivity issues might get ya, though.  

Expect problems.  It's 4D.

Linguinut
------------------
Bill Cunnien
ConBrio Consulting

RE: Oracle to 4D

(OP)
Thank you very kindly for your quick response.

We are in the process of acquiring all the software needed to give it a try.

I might have additional questions once we get "neck deep" in the process.

thanks again

domingas

RE: Oracle to 4D

Follow up.

DO NOT USE ODBC!!

BLOB fields will make it cough, choke and die!

Export table by table in the following manor:

1) Field delimiter: 179 (pipe)
2) Record delimter: 126 (tilde)
3) Do not add line feed
4) Save to a flat text file
5) Eliminate text qualifiers from the import procedure.
6) Check dates during the import, if necesary

My final destination was SQL Server.  I made it.  A lot of headaches along the way, though.  Maybe it all works better in the most recent version.

Best of luck!  Let me know if I can answer any other questions.  I'd be glad to help anyone get away from 4D.

Linguinut
------------------
Bill Cunnien
ConBrio Consulting

RE: Oracle to 4D

Domingas,

I recently started a project with the same task, migrate 4D data to Oracle.

I would REALLY appreciate any "lessons learned" or information about your solution.

Thanks so much,

Rick Young
rick.young@sysev.com

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close