Solved

ODBC transfer between Filemaker and Netsuite

Posted on 2010-11-17
2
1,338 Views
Last Modified: 2012-05-10
Hi Experts,

I have a Filemaker Database for the factory and NEtsuite for the Executives.  I want to automatically transfer data from filemaker to Netsuite. Both databases say they have ODBC capabilities so does that mean I can do the transfer?

Or is there a better alternative other than ODBC?

Many Thanks,

0
Comment
Question by:J3D1-KN1G1-1t
2 Comments
 
LVL 9

Accepted Solution

by:
jvaldes earned 250 total points
ID: 34156472
I have not used NetSuite but, you are correct that you can transfer data between these two as long as Netsuite's ODBC driver allows imports or if Netsuite uses Microsoft SQL, MySQL or Oracle which directly connect to Filemaker.  
0
 
LVL 28

Assisted Solution

by:lesouef
lesouef earned 250 total points
ID: 34179380
I doubt netsuite let's you write to their db in SQL mode, and you would not either let anyone from outside to read in your fm db from outside in SQL mode? so see what import methods are available at netsuite, but this is probably a csv file only.
0

Featured Post

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

Entity Framework is a powerful tool to help you interact with the DataBase but still doesn't help much when we have a Stored Procedure that returns more than one resultset. The solution takes some of out-of-the-box thinking; read on!
CCModeler offers a way to enter basic information like entities, attributes and relationships and export them as yEd or erviz diagram. It also can import existing Access or SQL Server tables with relationships.
The purpose of this video is to demonstrate how to set up the WordPress backend so that each page automatically generates a Mailchimp signup form in the sidebar. This will be demonstrated using a Windows 8 PC. Tools Used are Photoshop, Awesome…
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…

706 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now