What will be the best integration solution

[CodersArcade]

Our goal is to establish Integration A, which serves as a data repository. The data stored in Integration A is then utilized in another recipe, Integration B, to ascertain the appropriate endpoint for data transmission. What is the most effective method to accomplish this within Workato? The current proposal involves storing data in a lookup table. Are there any superior alternatives or recommendations

[LcPaJMWV]

1. ---

   @CodersArcade wrote:
   

   Our goal is to establish Integration A, which serves as a data repository. The data stored in Integration A is then utilized in another recipe, Integration B, to ascertain the appropriate endpoint for data transmission. What is the most effective method to accomplish this within Workato? The current proposal involves storing data in a lookup table. Are there any superior alternatives or recommendations

   ---

   
   

[girish-naralla]

In my opinion, Data Tables serve as a more robust and scalable alternative to Lookup Tables, especially for use cases involving larger datasets, complex filtering, or relational-like structures.

Below, I’ve outlined the key limitations of both Lookup Tables and Data Tables. Please review them to understand which option best suits your needs. If you need further assistance or a recommendation based on your specific use case, feel free to reach out.

Lookup Table Limitations

• Max 100 tables per workspace
• Max 10 columns per table
• Max 100,000 rows per table (enforced from June 2025)
• Limited filtering and sorting capabilities
• Not suitable for relational data or storing large blobs

Data Table Limitations

• Max 100 tables per workspace
• Max 1,000,000 rows per table
• Max 100 columns per table
• Max 1 GB total table size
• Advanced filtering, sorting, and linking capabilities

[mppowe]

I agree that Data Tables are a better option now over Lookup Tables.  At the time I wrote my original responses, Data Tables were tethered to Workflow Apps, thus an add-on to be bought.  Within the last couple months I noticed Data Tables present and seemingly available to us, so I think there have been some licensing changes around that.  So if they're available, then yes they can make more sense depending on the use case.  Lookup tables are really meant more for quick translations of values rather than data storage