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
Bedrock Mission!

Learn more

View all

Sign in to view all badges

The 4th edition of the Campaign Community Lens newsletter is out now!
SOLVED

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

Avatar

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

Avatar

Correct answer by
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

2 Replies

Avatar

Correct answer by
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

Avatar

Administrator

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!