SQL in the archive object

0

Hi, the data is archived in your SQL Archive database, and you can extract data from it.
Additionally, you can use the data from the archived database to create reports.
https://kb.webcon.pl/elementy-zarchiwizowane-dostepne-w-raportach-aplikacji-oraz-zrodlach-bps/

I need to show SQL data on the order form, but from a different database.

You have to create an additional connection for the database and then you will able to use the connection in source for a SQL row / grid

the topic concerns an archived item, native SQL ROW and grid is disabled as in my screenshot

Łukasz, show us the full configuration you want to perform, because presenting data on forms from the archive database is nothing more than writing an SQL query to the archive database, and no dedicated permissions are required here.

How do you do your full configuration?

This isn't about the archive database, but about the archived item. SQL attributes are natively disabled on archived items. See the screenshot. There's no data preview for the archived item.

In WEBCON BPS, once an item is archived, SQL attributes / business rules can’t be evaluated anymore, since the archived workflow instances are stored in a compressed, read-only format.
That’s why the data preview and calculated attributes are disabled — you can only access metadata (like workflow ID, instance number, date, etc.), but not the live field data.