04-24-2024 07:16 AM
Hello All,
We are in a pickle here with autofills as we grow the business by leaps and bounds. The DBA team is creating a separate database for each LOB. What I need to do is set up OnBase to be able to read multiple databases and retrieve member demographics information.
Currently, we have a database called “PA-ODS” we look at the member ID, Member Name, DOB, and Address.
Starting in 2 months, we will have four new databases for new lobs.
We have a second database called OH-ODS. Again, we look at the member ID, Member Name, DOB, and Address.
The field names are exactly the same; the only thing different is the database name.
How would you create one unity script to capture data from all four databases?
Any help would be greatly appreciated.
04-24-2024 08:02 AM
I use PowerShell to create a CSV for my AFKS files. In this case I would query each database and append the results to the CSV. I can then sort and otherwise manipulate the data before saving a final copy to my AFKS folder.
When working with data from multiple sources, ensure that you have unique primary values across all datasets. The member ID should be unique for each row. If they are duplicated on another database that will cause issues.
You can ask ChatGPT or copilot to "Create a PowerShell script to query 4 databases for member ID, Member Name, DOB, and Address and append the results to a CSV then sort and otherwise manipulate the data before saving a final copy to my AFKS folder."
04-24-2024 03:41 PM
I would create a view that looks across all the databases and gets all the data - probably 4 unions in your case. Then I would point my autofill to this view. If this runs too slow, then I would use a a scheduled powershell script to dump the view to a local table and I would point the autofill to that table.
04-24-2024 08:02 AM
I use PowerShell to create a CSV for my AFKS files. In this case I would query each database and append the results to the CSV. I can then sort and otherwise manipulate the data before saving a final copy to my AFKS folder.
When working with data from multiple sources, ensure that you have unique primary values across all datasets. The member ID should be unique for each row. If they are duplicated on another database that will cause issues.
You can ask ChatGPT or copilot to "Create a PowerShell script to query 4 databases for member ID, Member Name, DOB, and Address and append the results to a CSV then sort and otherwise manipulate the data before saving a final copy to my AFKS folder."
04-24-2024 03:41 PM
I would create a view that looks across all the databases and gets all the data - probably 4 unions in your case. Then I would point my autofill to this view. If this runs too slow, then I would use a a scheduled powershell script to dump the view to a local table and I would point the autofill to that table.
04-25-2024 06:00 AM
04-25-2024 12:08 PM
Find what you came for
We want to make your experience in Hyland Connect as valuable as possible, so we put together some helpful links.