Trying to get my first DAC to work. I am trying to retrieve data from a separate Azure database on the same network.
When I create the code file I get “Cannot generate members of the DAC: A table with the specified name does not exist in the database.”
I have a data provider created, but can’t figure out where acumatica connects to the other data. Is there a setup step still missing?
Best answer by Marco Villasenor
Hello, the Acumatica Framework does not expose a mechanism to connect to external databases. You would need to write that on your own code and read the data through your connection, then manually fill the DAC values. Having said that, you would need to query the data each time as it would only be stored in memory. If you need it to be available between sessions and be avaiable from other tools like Generic Inquiries you need to create a table for the custom DAC and persist the data once you get it from the external DB. Depending on how often your external data changes you could also use import scenarios to pull it into your custom DAC.
+7
If you want to read data via Acuamtica framework from a DB, that must be the same DB Acumatica is connected to.
+3Hello, the Acumatica Framework does not expose a mechanism to connect to external databases. You would need to write that on your own code and read the data through your connection, then manually fill the DAC values. Having said that, you would need to query the data each time as it would only be stored in memory. If you need it to be available between sessions and be avaiable from other tools like Generic Inquiries you need to create a table for the custom DAC and persist the data once you get it from the external DB. Depending on how often your external data changes you could also use import scenarios to pull it into your custom DAC.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
