Using "Changing Only" for Data Source Type with multiple GP tables
Lewis asked 5 years ago
When using “Changing Only” for Data Source Type with joining multiple GP tables (SY01200 & PM00200).. Can the “Microsoft Change Data Source” Data Source Type be used or will the “MSSQL Table Change Data Source” Data Source Type be required?
Example
SELECT * FROM PM00200
LEFT JOIN SY01200 ON PM00200.VENDORID = SY01200.MASTER_ID AND
PM00200.VADDCDPR = SY01200.ADRSCODE AND
SY01200.MASTER_TYPE = ‘VEN’
Example
SELECT * FROM PM00200
LEFT JOIN SY01200 ON PM00200.VENDORID = SY01200.MASTER_ID AND
PM00200.VADDCDPR = SY01200.ADRSCODE AND
SY01200.MASTER_TYPE = ‘VEN’
Answers
Lorren Zemke Staff answered 5 years ago
Lewis,
You can use the either the Dynamics GP Change Only or MSSQL Change Data Source. In both cases, click on the modify button and you will then be able to add additional tables to your query.
The main point to understand is that you need to make sure you use the right join type to ensure you get data when the integration executes. As above, you have a Left Join, so within the Modify query window, you can right click the link line and choose that proper join type.
Lorren
You can use the either the Dynamics GP Change Only or MSSQL Change Data Source. In both cases, click on the modify button and you will then be able to add additional tables to your query.
The main point to understand is that you need to make sure you use the right join type to ensure you get data when the integration executes. As above, you have a Left Join, so within the Modify query window, you can right click the link line and choose that proper join type.
Lorren
Lewis replied 5 years ago Lorren.. Thank you for the reply, this question is resolved.