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

[#1]

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:

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

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

Is there something wrong or error config lead this ? 

[#2 · Accepted solution]

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

[#3]

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!