You’re offline. This is a read only version of the page.
1,550
Dear Experts,
I have a requirement to show both Masters Data and Transaction Data from GP to other systems.
Please help me with best way to reach this requirement.
Thanks,
Praveen
*This post is locked for comments
I am actually aiming for exactly same thing - using EONE SmartConnect at the moment. The question is - how often do you need to export this data and if you need "as close to real time as possible" on every transaction & master data update or infrequently run batch job will do. SmartConnect has the means of achieving both aims. For real time they have something named "GP real time data source" that you can point to almost any master or transaction data and have it as source for the SmartConnect mapping. Output of the mapping can be a file, SQL Server table, stored procedure etc. GP real time data sources create SQL server triggers on the GP tables involved but all of it is hidden from you as developer, so you need only to care about the logic. SmartConnect also has "bulk load" type of data source that can be pointed to any GP data and it has scheduling facility, so you can have your "bulk load" map executed on the required schedule.
I am in the early stages of development of my project and seems like SmartConnect is the obvious way to go, but in my case I need to get GP data delivered to external database (MySQL) as close to real time as possible. My concern is ease of support for SmartConnect maps in production environment. I want to be able to look at the logs easily and being able to troubleshoot also is very important. So from this prospective, set of data extract scripts wrapped in the regularly executed job looking for data changes in GP tables since the last run seems like a more common-sense approach, even though probably much more labor intensive. This can be written in any language you are comfortable with as long as it allows to connect to SQL server and run queries.
One more thing - SmartConnect is quite expensive.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (