# What is the difference between Stream Lookup and Database Lookup?

**URL:** <https://community.automationedge.com/t/what-is-the-difference-between-stream-lookup-and-database-lookup/17835>\
**Category:** Process Studio\
**Tags:** ps-steps\
**Created:** [April 23, 2026, 4:33am UTC](https://community.automationedge.com/t/what-is-the-difference-between-stream-lookup-and-database-lookup/17835 "2026-04-23T04:33:45Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![nishaautade](https://avatars.discourse-cdn.com/v4/letter/n/7cd45c/32.png) [@nishaautade](https://community.automationedge.com/u/nishaautade)\
**Post date:** [April 23, 2026, 4:33am UTC](https://community.automationedge.com/t/what-is-the-difference-between-stream-lookup-and-database-lookup/17835/1 "2026-04-23T04:33:45Z")

</div>

What is the difference between Stream Lookup and Database Lookup?

---

<div class="post-metadata">

**Author:** ![AETrainings](https://avatars.discourse-cdn.com/v4/letter/a/2acd7d/32.png) [@AETrainings](https://community.automationedge.com/u/AETrainings)\
**Post date:** [April 25, 2026, 10:00am UTC](https://community.automationedge.com/t/what-is-the-difference-between-stream-lookup-and-database-lookup/17835/2 "2026-04-25T10:00:45Z")

</div>

Stream Lookup  
The Stream Lookup step is used to enrich data in a workflow by looking up values from another source (such as a file or secondary stream). Data from source steps is cached in memory, and a common key field is used to match and retrieve the required values. The matched data is then added to the main data stream.

Database Lookup  
The Database Lookup step is used to fetch values directly from a database table. Based on a key field, it retrieves matching records and adds the lookup values as new fields to the existing data stream.