Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn more

View all

Sign in to view all badges

SOLVED

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

yueminspb
Level 3
Level 3

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 ? 

1 Accepted Solution
Milan_Vucetic
Correct answer by
Community Advisor
Community Advisor

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

View solution in original post

2 Replies
Milan_Vucetic
Correct answer by
Community Advisor
Community Advisor

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

View solution in original post

Sukrity_Wadhwa
Employee
Employee

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!