We use a homebrew ERP system based on MySQL & Perl.
In Salesforce accounts we need some picklists to select values from specific MySQL tables (only reading from external system is required). New values will be added to required tables every few days, Salesforce accounts will be edited each day.
My first idea was to create a new custom object for each MySQL table which contains the value and its MySQL Id. A new lookup field would be added to account. And each time values change in our system a script using the API synchronizes tables with custom objects.
I read documentation about external data sources and objects: https://help.salesforce.com/articleView?id=external_data_sources.htm&type=5 https://help.salesforce.com/articleView?id=000329420&type=1&mode=1
But I don't see a way to let Salesforce read my MySQL tables, generate related objects and repeat that when data changes. So is there an easier solution than my one?