Columns of Oracle Dataset are Not Shown in API Response

Question

Columns of Oracle Dataset are Not Shown in API Response

Vegnesa, Savio 0

Hi team,

I have created one Dataset in Azure Data Factory using Oracle, and i want to get the Column of this dataset using API. I've encountered an issue while attempting to fetch columns for an Oracle dataset in Azure Data Factory using the API. Despite utilizing the following endpoint:

GET https://management.azure.com/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.DataFactory/factories/{factoryName}/datasets/{datasetName}?api-version=2018-06-01

I'm unable to retrieve the columns for the Oracle dataset. The response I receive does not include the expected column information.

User's image

Could you please assist in identifying the correct API endpoint or any additional steps required to fetch the columns for Oracle datasets via the API?

1 answer

Your answer

Answer 1

AnnuKumari-MSFT 34,556 Microsoft Employee Moderator

Hi Vegnesa, Savio ,

Welcome to Microsoft Q&A platform and thanks for posting your query.

As per my understanding, you are trying to fetch the column names out of the oracle table using REST API call on the dataset via ADF, however, the output is not coming as expected. Please let me know if that is not the clear understanding.

I tried to reproduce your scenario with Azure SQL table since I do not have oracle table to repro right now but I got the expected result. Kindly check if you are doing something incorrectly.

Kindly make sure the table is selected in the dataset and schema has been imported. Try to import the schema again and run the pipeline

I used web activity to make the REST api call using the above URL you shared and it gave expected result. Here is more details:

User's image

Hope it helps. Kindly accept the answer by clicking on Accept answer button if it helped. In case you have any further query, kindly let us know in comment. Thankyou

Vegnesa, Savio 0 Reputation points

2024-03-07T13:50:48.22+00:00

Apologies for the lack of detail in my previous question. I am using Copy Activity to transfer data from Oracle to SQL Database as Shown below.

I've added Oracle table as a source in my copy data activity, and I can view its columns in the preview tab as shown below .The schemas were successfully imported, and the pipeline has been executed without any issues

However, when I make a request to the 'Get Dataset by Name' API via postman i am not able to get columns

GET https://management.azure.com/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.DataFactory/factories/{factoryName}/datasets/{datasetName}?api-version=2018-06-01

Currently, I'm facing an issue specific to Oracle datasets. While I'm able to retrieve column information successfully for other datasets such as Azure SQL Database, SQL Server, and Snowflake using the API
AnnuKumari-MSFT 34,556 Reputation points Microsoft Employee Moderator

2024-03-07T17:42:40.1866667+00:00

Vegnesa, Savio ,

Thanks for sharing more details. So, as per my understanding, this issue is not with other connectors , neither with ADF as It seems like API endpoint is working fine with all other datasets. I would check internally with the team to check if the above Rest api is supported with oracle connector or not or any known bug is there , however, I would suggest you to take it forward to the oracle community platform as well as and see if any relevant help is provided .
Vegnesa, Savio 0 Reputation points

2024-03-20T06:42:44.7266667+00:00

Any updates regarding the Rest API's compatibility with the Oracle connector for Copy Data Activity ?
AnnuKumari-MSFT 34,556 Reputation points Microsoft Employee Moderator

2024-04-02T09:23:06.4266667+00:00

Vegnesa, Savio ,

Haven't got any response from the internal team on this issue. I will suggest you to create azure support ticket to investigate further . Thankyou

Share via

Columns of Oracle Dataset are Not Shown in API Response

1 answer

Your answer