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

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

Avatar

Avatar
Validate 10
Level 1
yueminspb
Level 1

Likes

0 likes

Total Posts

38 posts

Correct Reply

0 solutions
Top badges earned
Validate 10
Validate 1
View profile

Avatar
Validate 10
Level 1
yueminspb
Level 1

Likes

0 likes

Total Posts

38 posts

Correct Reply

0 solutions
Top badges earned
Validate 10
Validate 1
View profile
yueminspb
Level 1

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 (1)

Accepted Solutions (1)

Avatar

Avatar
Contributor
MVP
Milan_Vucetic
MVP

Likes

161 likes

Total Posts

380 posts

Correct Reply

134 solutions
Top badges earned
Contributor
Springboard
Shape 1
Validate 25
Validate 10
View profile

Avatar
Contributor
MVP
Milan_Vucetic
MVP

Likes

161 likes

Total Posts

380 posts

Correct Reply

134 solutions
Top badges earned
Contributor
Springboard
Shape 1
Validate 25
Validate 10
View profile
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

Answers (1)

Answers (1)

Avatar

Avatar
Validate 500
Employee
Sukrity_Wadhwa
Employee

Likes

133 likes

Total Posts

807 posts

Correct Reply

35 solutions
Top badges earned
Validate 500
Validate 250
Validate 100
Validate 25
Validate 50
View profile

Avatar
Validate 500
Employee
Sukrity_Wadhwa
Employee

Likes

133 likes

Total Posts

807 posts

Correct Reply

35 solutions
Top badges earned
Validate 500
Validate 250
Validate 100
Validate 25
Validate 50
View profile
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!