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.
Subscribe to:
Post Comments (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...
-
This month Microsoft announced the availability of Dynamics GP 2013 demo which you can download here . Most of the improvements were geare...
-
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...
1 comment:
I would suggest using SQL Server Integration Services in combination with the Dynamics GP SSIS Toolkit rather than going through the hassel of creating your own windows service that interfaces with eConnect.
With SSIS you can customize every aspect of the integration with .NET code if you wanted to but most of the out of the box adapters will get you what you need such as event logging, email functionality, automated webservice and FTP interaction etc.
The toolkit integrates all the business objects that are supported by eConnect and is 1/5 the cost of integration manager or Scribe.
The Dynamics GP SSIS Toolkit can be purchased here:
http://www.keelio.com
Post a Comment