SQL 2005 connects with Great Plains??

Question

SQL 2005 connects with Great Plains??

nelronllc

SSC Veteran

Points: 218
More actions
March 26, 2010 at 11:42 am

#213202

Ok I need to load data from SQL 2005 into Great Plains, any ideas?
thank you

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Phil Parkin SSC Guru Points: 246960 More actions · Answer 1

Get Great Plains' database schema, build a mapping document, then write the conversion in SSIS.

The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin

Lowell SSC Guru Points: 323518 More actions · Answer 2

Great Plains is an application which can use SQL Server as it's database.

Great Plains versions 5 through 6 offered a number of database options, including c-tree, pervasive, and MSSQL 7-2000.

At least two of my clients currently have Great Plains V8 on SQL 2005 and 2008;

so Great Plains itself is not a database system, but an application that uses a database.

can you explain or research a bit more on what you are refering to?

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

emily-1119612 SSCarpal Tunnel Points: 4166 More actions · Answer 3

I would check with GP and see if this is supported. Some systems especially accounting systems don't support direct updating of the database and you may damage data integrity.

They may have a specific import process that needs to be followed.

If it was reference data I might be tempted to go for it, but transactional data, no way.

nelronllc SSC Veteran Points: 218 More actions · Answer 4

Yeah I'm trying to figure out whats going on here, this is my first day at work and my task is to fix

that great plains mess they have here, as far I know, they get a flat file and load it into access and then into SQL and then use a eConnect to load that data into Great Plains, not sure why yet.

I will let you know later on today.....thanks

emily-1119612 SSCarpal Tunnel Points: 4166 More actions · Answer 5

eConnect is the accepted GP mechanism for importing data. Good luck.