RE: Connect to Cloud-hosted environment database
Good morning,
Here is my case scenario.
I did all the process to do the export to data lake and deployed the CDMUtil function app to read the csv and create the schema of the views.
I am having issues reading the schemas of the views, I am not sure why.
We need to add the following parameters to the configuration files.
<add key="ProcessSubTableSuperTables" value ="true"/>
<add key="AXDBConnectionString" value ="Server=DBServer;Database=AXDB;Uid=youruser;Pwd=yourpassword"/>
I know that I can request an 8 hours access to the database, but those details need to be requests as needed and probably the password will change every time.
So I am trying to find a solution to connect to my cloud environment, as when I asked for the permission to connect to the DB on UAT and I added the connection it did not read the schema of the entity.
Any ideas how to use that AXDBConnectionString connection or better said, where to connect it?
Thanks
Astrid