Epicor 9 (Progress DB) extract to SQL table

Yahoo Archive
1

Can you add a linked server in MS SQL --- for the Progress db using the ODBC driver?
I did this for an old V6/Progress database & was then able to use it for external BAQs in the new E9/SQL system.
Everything had to be 32 bit for it to work, I think I've used SQL Express 32 bit at least once where all the existing SQL servers were 64 bit.
2

I need help/recommendation on the best tool or process to extract particular data from Epicor 9.05(Progress DB) to an SQL table.  It is only particular records that I will extract. 
3

MS-Access via ODBC was what I used to use for this sort of thing.  Worked well enough with an Update query.  I used it for tracking commissions.  Not sure about it being “best” but since I knew Access it was best for me.

-Todd C.

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Tuesday, November 03, 2015 2:01 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Epicor 9 (Progress DB) extract to SQL table

 

 

I need help/recommendation on the best tool or process to extract particular data from Epicor 9.05(Progress DB) to an SQL table.  It is only particular records that I will extract. 

4
I have done this type of extract with access before.  I unfortunately have to be able to get it in Simple XML or be able to put it in an SQL table.  this data is being added to a staging table that will be maintained by another sister company. 
5
Is this going to be a one time transfer? Or will they be pulling from that DB constantly and then editing data? Can you provide the data you are wanting done?