I've seen a couple of post requiring data to be imported into GP but needs to be QA'ed. Example, let's say you have an e-Commerce system where orders get created and are manually entered in GP as Sales Orders. While entering in GP, the user make changes to amounts, quantities, prices, costs,etc.
Over the years, Microsoft Dynamics had been creating tools to make integration easier to manage. You can create interfaces using GP Web Services and this can reside outside GP where you can QA data before the actual import happens. The advantage? You're not using any GP license.
Another tool you can use - eConnect. A lot of GP vendors have created eConnect templates for ease-of-use and faster ROI.
You can also look at SQL Server Integration Services. This improved version of DTS is a true ETL solution for enterprises.
My 2 cents, spend more time choosing the right tool as each can have their pros and cons. Also consider creating a Staging database when you're not sure if data is reliable enough to be imported to GP.
This blog was created to help Program leads, solution architects and administrators of different enterprise solutions including ERP, CRM, SCM, WMS, PLM, Business Intelligence and many more.
Friday, May 16, 2008
Subscribe to:
Posts (Atom)
e-Commerce discount types
In the world of retail today every retailer is trying to find ways and be creative to attract online customers. To attract your attention an...
-
The first time that you log in to Microsoft Dynamics GP 9.0, you can select to have default information that is specific to your job display...
-
I've filled out the survey and chose the functionalities I think would benefit a lot of industries. Below is a summary of the survey I s...
-
This month Microsoft announced the availability of Dynamics GP 2013 demo which you can download here . Most of the improvements were geare...