Wilsonjr's avatar
Wilsonjr
Frequent Visitor
4 years ago
Status:
Investigating

Datamart to Datamart connection issues

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...
Data Modeling
v-cazheng-msft's avatar
v-cazheng-msft
Icon for Community Support rankCommunity Support
4 years ago
Status changed:
New
to
Investigating

Hi Wilsonjr,

 

I’ve tested the connection from one Datamarts to another Datamarts and there is no issue on connection. But in my scenario, I don’t configure MFA and the data amount is not so large.

 

Consider the usage of MFA and the large data amount, I would suggest you try these steps.

1 Make sure the connection info is correct

Server name is the Server connection String you copy from the upstream Datamarts Settings page

Database is the name of the upstream Datamarts

Authentication account is who creates the upstream Datamarts

 

2 Prolong the timeout as long as it is less than 2 hours which is the maximum

 

3 connect with the help of Gateway

Please register the data source to your gateway firstly and then recreate your new Datamarts with this configured gateway

 

Best Regards,                                                          

Community Support Team _ Caiyun

Completed Ideas