External Database account connection OK, but can not get table list

Avatar

Avatar

yueminspb

Avatar

yueminspb

yueminspb

07-01-2021

Hi Team,

We created a external database account which is a Microsoft SQL server.

The connection between ACC server and database tested OK, like this:

yueminspb_0-1610014771410.png

In the workflow,  when we want to use this external account for data loading by RDBMS, table list can not be shown  completely.

yueminspb_1-1610014977825.png

But in Datagrip, we can see all the table we needed by the same db user

yueminspb_2-1610015069459.png

Is there something wrong or error config lead this ? 

Accepted Solutions (0)

Answers (2)

Answers (2)

Avatar

Avatar

Sukrity_Wadhwa

Employee

Avatar

Sukrity_Wadhwa

Employee

Sukrity_Wadhwa
Employee

13-01-2021

Hi @yueminspb,

Were you able to resolve this query with the given solution or do you still need more help here? Do let us know.

Thanks!

 

Avatar

Avatar

Milan_Vucetic

MVP

Avatar

Milan_Vucetic

MVP

Milan_Vucetic
MVP

07-01-2021

Hi @yueminspb 

check if you can select data from tables in Datagrip (is not enough to be visible only).

Other step is to make deployment of FDA functions to the database (second tab in in the external database account).

Regards, Milan