Expand my Community achievements bar.

Enhance your AEM Assets & Boost Your Development: [AEM Gems | June 19, 2024] Improving the Developer Experience with New APIs and Events

OLEDB Stored Proc w/ parameter


Former Community Member
I'm trying to connect to a SQL Server DB to automatically fill certain form fields. I can create the connection, but then I am presented with a screen to select the data collection method - either Table, Stored Procedure, or SQL Query. I choose Stored Proc, but when I try to proceed I get the following error:

Stored Procedure has non-optional parameters.

How do I pass the stored procedure the parameter?
1 Reply


Level 1


As far as I know InDesign takes flat files or XML. Conversion may be required in database before input.