Forum Discussion
DonLarson
4 years agoQrew Commander
Graham,
How much control do you have over system #2? You can extract the table in QB on a regular schedule and put it into system #2 or even a third standalone DB​​. Then system #2 can execute a SQL Query to retrieve the record from there. Depending on your business case, running an extract once a day or less might be sufficient for your new data warehouse to serve up answers to system #2.
​
------------------------------
Don Larson
Paasporter
Westlake OH
------------------------------
How much control do you have over system #2? You can extract the table in QB on a regular schedule and put it into system #2 or even a third standalone DB​​. Then system #2 can execute a SQL Query to retrieve the record from there. Depending on your business case, running an extract once a day or less might be sufficient for your new data warehouse to serve up answers to system #2.
​
------------------------------
Don Larson
Paasporter
Westlake OH
------------------------------