Hi Rodrigo
Property files can be transferred to the database, and used by the SI Application at runtime from the database, and then read from the property file cache as an alternative if the property key is not defined in the database.
It is anticipated that that sci-get-property() function should return the database value if it is available, or the value from the property file cache if it is not.
There will be some interest in maintaining a version of property value, like workflow definitions and service instance parameters, and an audit of users making changes.
Related documents regarding using the sci-set-property usage and common issue resolution
How to use the sci-set-property function
https://www.ibm.com/support/pages/how-use-sci-set-property-function
Additional common issue for clustered SI setup:
Assign with sci-get-property failing
https://www.ibm.com/support/pages/assign-sci-get-property-failing
sci-get-property does not retrieve the changed parameters in properties file:
Symptom
After making changes to a custom properties file and using the cache refresh service to refresh the parameters, the assign to retrieve the changed parameters still returns the old values
https://www.ibm.com/support/pages/sci-get-property-does-not-retrieve-changed-parameters-properties-file
Example Syntax:
<sequence>
<assign to="Userid" from="sci-get-property('security','passphrase')"></assign>
</sequence>
</process>
Using the customer_overrides in the Customization-UI
https://www.ibm.com/support/pages/using-customeroverrides-customization-ui
Best Regards
------------------------------
Ashish Garg
------------------------------
Original Message:
Sent: Tue August 06, 2024 11:52 AM
From: Rodrigo Ricardo Pérez memije
Subject: replace reading properties in file system and use a database to read it instead
Thank you for your kind response, my friend. I see that by installing the b2bapi, it could be possible to read the properties from a database table. I'm a bit lost on the part about customization UI; does that refer to changes in the interface? I suppose it would be modifying the custom properties
------------------------------
Rodrigo Ricardo Pérez memije
Original Message:
Sent: Tue August 06, 2024 01:43 AM
From: KALYAN PAVAN KISHORE CHAKRAVARTHULA
Subject: replace reading properties in file system and use a database to read it instead
The customization UI introduced a few years back stores the property files in the DB. You can still query the property files using sci-get-property. So, no changes are required in your existing bps.
You need to deploy B2BAPI to leverage this feature. I hope the below IBM knowledgecenter helps.
https://www.ibm.com/docs/en/b2b-integrator/6.2.0?topic=customizations-property-files
------------------------------
KALYAN PAVAN KISHORE CHAKRAVARTHULA
IBM Technology Expert Labs
IBM
Original Message:
Sent: Mon August 05, 2024 04:12 PM
From: Rodrigo Ricardo Pérez memije
Subject: replace reading properties in file system and use a database to read it instead
Is it possible to replace the properties file with a properties in a database in a table and use them through sci-get-properties() ? I see that the properties are stored in the Sterling cache. I know it would be slower, but it would have advantages like having everything centralized and better control over them. I can think of a Java task that reads the tables and generates a file in the filesystem, and it would continue to be used traditionally, but I'm not sure if it's possible to modify some configurations and read directly from the table. I appreciate your attention
------------------------------
Rodrigo Ricardo Pérez memije
------------------------------