We are working on trying to have a datamart read/query a second datamart to get specific data. We are running into a couple of issues: Firstly, when attempting to set up the connection I typically g...
This simi worked by creating the Gateway, once you get the table added however, any existing table looses it's credentials and you are unable to edit the credentials. The work around was to instead re add a table from the same data source, which auto fills the credentials for the broken tables. You then can delete the extra tables you added. I appreciate the speedy response. MFA is dirty when it comes to DB's trying to talk to each other. Hoping I can work with my team on a better solution that doesnt utilize MFA but for now this will work thank you!