Getting Started

 View Only

Using Pipelines to copy table data vs. cross-app relationships

  • 1.  Using Pipelines to copy table data vs. cross-app relationships

    Posted 05-16-2022 11:03
    I have what I think is a fairly simple question, but would like an opinion as to what the best approach is to take to accomplish something.  

    I have two apps where I would like to copy table data from one app to another.  I would like to copy a "zip codes" table from App B into App A and have a Pipeline keep these tables synced.  Keep in mind, this zip code table is not changed very often, maybe a few times a week.  About 90 users use App A throughout the day but there is a downtime from 8 PM to about 4 AM each night/morning where few, if any, users are in the system. 

    Should I have the Pipeline copy data as things change, or trigger on change, or should I run a nightly update where this happens automatically in order to prevent any slowdown in App A as things sync?  What's the most efficient approach?

    ------------------------------
    AR
    ------------------------------