How to create a dataset to dblink

63877242 1

Hello,
is it possible to create a dataset that connects to an Oracle dblink? In the list of tables shown there are no references to the dblink.

Thank you

Massimiliano

AnnuKumari-MSFT 31,061 Reputation points Microsoft Employee

2023-03-30T05:40:41.36+00:00

@63877242 ,

Just checking in to see if the below answer helped. Please do consider clicking Accept Answer as accepted answers help community as well. Also, please click on Yes for the survey 'Was the answer helpful'

1 answer

AnnuKumari-MSFT 31,061 Reputation points Microsoft Employee

2023-03-29T10:47:15.2666667+00:00

Hi 63877242 ,

Welcome to Microsoft Q&A platform and thanks for posting your query. As I understand your question, you want to know how to create a dataset for oracle DBLink. Please let me know if that is not the case.

Dataset is a reference to the datastore created on top of the linked service which holds the connection string for the datastore. So, dataset can be created for a particular datastore.

For instance, Oracle is a relational database management system (RDBMS) that stores and manages data in a structured format. On the other hand, Oracle Database Link (DBLink) is a feature that enables a database to access data in another database , it is like a connection between two databases.

So, we can't create a dataset for Oracle DB link, but we can create it for Oracle database.

For more details , kindly visit : Copy data from and to Oracle by using Azure Data Factory or Azure Synapse Analytics

Hope it helps. Kindly accept the answer if it helps.
Please sign in to rate this answer.
63877242 1 Reputation point

2023-03-30T13:50:58.8766667+00:00

ok thanks!

my dblink is only a way to connect to sap, my goal is to write data from a file into sap table.

now I now it's not possibile to sink data into an oracle dblink; I tried also to do the sink passing through a "SAP Table" dataset, but it seems that even this is not possible.

So, how can I write into sap table through a copy activity?

63877242 1 Reputation point

2023-03-30T14:08:11.1+00:00

Ok thanks!

My goal is to write a data into SAP table throgh a Copy activity; it seems to be not possible, neither by passing through a dblink oracle nor with a SAP Table object (it doesn't appear in the list of datasets in the sink).

Is there a way to write into a SAP table from a copy activity?

AnnuKumari-MSFT 31,061 Reputation points Microsoft Employee

2023-04-05T07:46:32.19+00:00

63877242 You can use the SAP table connector in Azure Data Factory to copy data from a source data store to an SAP table. You can find more information on how to use the SAP table connector in Azure Data Factory here: Copy data from an SAP table using Azure Data Factory or Azure Synapse Analytics Hope it helps. Kindly accept the answer as accepted answer helps community as well

AnnuKumari-MSFT 31,061 Reputation points Microsoft Employee

2023-04-24T07:36:21.9866667+00:00

63877242 , Kindly accept the answer if it was helpful as accepted answer helps community. Thankyou
Sign in to comment