Posted: 8 Jun 2018 13:30 EDT Last activity: 26 Jun 2018 10:24 EDT
What is best practice to storing data?
Hello, i would like know what is best practice to Pega, for extend a data base model, what is the best practice for add colums to a Table?, like add new tables the model?
What is the best practice for storing information that was consulted on a external service. We have a service (a bureau) that return a lot of information of a client and just we will need a little bit of this information and stored all data that return the request, so we need know what is the best practice, if storing on Pega or a external data base out of Pega
It depends on your requirement and application design. You can store the data in internal Pega DB as long as the DB can accomodate it without impacting the system performnace.
You can use an external database as well as Pega has functionalities to connect to an external database. All you need to do is create a Database rule in Pega specifying the external DB information and then use it as storage in your application flow.
One thing, if an external database is hosted in a different network, you might experience latency issues but its nothing to worry about as long as the proper network configurations is able to take care of that.
If the data is used only by Pega then it can be stored in pega database and if the same is used by some other applications then better to store in external database. And also before doing this just consider how frequently the data which is received from service will be changed if its changed do we need to update the data present in our local pega/external db.
It’s always best to create the datamodels inside your PegaApplication.
For retrieval purpose will recommend to use datapages to minimise the DB interactions which in turn improve application performance , and if you have lot of controls which needs to be show on the browser then divide the fields using multiple tabs use tabbed layouts or layout groups with deferred load options enabled.
In real time if you want data from outside pega, use connectors (soap ,rest etc) to consume the services(if available) retrieve the data and map it to pega properties .
At last in the unavoidable circumstance would recommend you to connect to the external DB and retrieve the data.