Hello All
The Datalake Export is generally working and we have many tables running and several entities (views) created.
However we are getting an error when running CDMUtil on these tables missing
as you can see most of these table names and with VIEW, so I guess somthing else is going on... These names cannot be found in the datalake export list...
Another issue we are having when creating entities is that some views refer these functions
Invalid object name 'dbo.GetValidFromDateInContextInfoAsTable'
Invalid object name 'dbo.GetValidToDateInContextInfoAsTable'
Thanks,
We indeed face issues to connect to the JIT access from outside.
We will have a try running this from the DEV server itself.
Regarding the cmdutil as a function app, I had to add replacement code to fix these function calls.
For cmdutil as console app you can add some key/value pairs to the ReplaceViewSyntax.json like this:
Hey fgs,
These views are internal and are not available through the F&O interface.
You can also specify a connection string to a development server to automatically create the views as they are defined in the database; that parameter would go in "AXDBConnectionString".
Note that to do that you would have to run the script from a place with a direct connection to that server; most easily that would be from the DEV server itself.
When I have faced this kind of problem what I have done is to manually create this views in synapse from the sql management studio, you can get the view definition from the sql server's development environment
André Arnaud de Cal...
292,031
Super User 2025 Season 1
Martin Dráb
230,868
Most Valuable Professional
nmaenpaa
101,156