SQL Driven Drop Lists in PDM
The best data may be available in another database already - capture it with SQL Drop Lists.
In PDM data card lists, you can define the data shown in three different ways: static typed-in lists, typed-in lists with aliases, and lists generated from SQL queries. This blog post will focus on the use of SQL to create drop-down lists on data cards.
PDM provides the capability to retrieve values from any SQL database that the company has query-level access to, and these values can be displayed in drop-down lists. Unfortunately, this feature of PDM is often overlooked. Many times, PDM architects end up duplicating data from other databases within PDM in a different format. This duplication can lead to various issues such as data synchronization problems when the source database is modified or changed, incorrect values being applied, and more.
Capturing data to populate drop-down lists using SQL offers a wide range of applications. Some common use cases include retrieving data from ERP systems for purposes such as displaying status information, commodity codes, disposition data, and much more. The possibilities are virtually limitless, making SQL a powerful tool for dynamically populating drop-down lists in various contexts.
Read these blogs to see some advanced ways to capture data from SQL calls.