skip to Main Content

I am new to Azure DataFactory.
I’m creating a pipeline and wish to connect to table via linked service.
I’ve created a linked service to the DB – the connection is successful.
When i try to create a Dataset with the linked service to the db,
and try to choose the table for the dataset (AZURE SQL),
there are no tables to choose from (Example in picture)

I need to choose a table for the dataset,
What am i doing wrong?

Add table Name

2

Answers


  1. if you managed to do a connection with the DB then your credentials are correct

    try this approach:

    create a pipeline in ADF, drag an activity , lets suppose its a lookUp activity .
    Drag this activity to the board/Canvas .
    click on the lookup activity -> settings tab

    in settings tab: source dataset -> your dataset
    on the same tab : you will see table drop down list, if your connection is correct , you need to specify which table you want to connect , after you finish,click on OK. this should work.
    if you dont see your dataset in the drop down list, try creating it again :

    under settings in lookup activity :

    source dataset -> new -> azure sql database -> click on continue
    enter a name to the dataset , after that under the linked service tab :
    click on new ,enter server name + credentials , test your connection and click on create

    Can you please explain how did you create the dataset ? maybe something is not working as expected.

    Login or Signup to reply.
  2. If you have selected the correct database in the linked service and the tables are available in the database, the tables list should be available in the drop-down.

    enter image description here

    1. Make sure you have selected the correct database in your linked service.

    2. Make sure the tables are available in the selected database. If tables were not created in the database, then the drop-down list of tables to choose in the Table name will not show anything (none).

    3. Sometimes, refreshing the table name gives the list if the tables are available in the database.

    enter image description here

    Login or Signup to reply.
Please signup or login to give your own answer.
Back To Top
Search