Azure Synapse Analytics

Question

Azure Synapse Analytics

Amit Kumar 0

-Is there any tool like ORACLE APEX for ORACLE DATABASE in Azure Environment

Where we can get data from ORACLE DATABASE

Anonymous

2023-12-21T04:14:28.4766667+00:00

@Amit Kumar Following up to see if the above answer was helpful. If this answers your query, do click Accept Answer and Yes for was this answer helpful. which might be beneficial to other community members reading this thread. And, if you have any further query do let us know.

1 answer

Your answer

Anonymous

2023-12-21T04:14:28.4766667+00:00

@Amit Kumar Following up to see if the above answer was helpful. If this answers your query, do click Accept Answer and Yes for was this answer helpful. which might be beneficial to other community members reading this thread. And, if you have any further query do let us know.

Answer 1

Subashri Vasudevan 11,306 Volunteer Moderator

Hi,

Edit

You can use Azure data studio to explore the Oracle database. Check the below URL for more details.

Azure Data Studio

You can also use copy activity in ADF / Synapse to connect to Oracle source and write the data to a file in azure storage or to an azure SQL table and use that file for further exploration. Or in case of synapse, you can write the data to a SQL pool table and use that as staging table for further transformation.

Hope that helps.

Anonymous

2023-12-19T15:51:52.2033333+00:00

@Amit Kumar Following up to see if the below answer was helpful. If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

Share via

Azure Synapse Analytics

1 answer

Your answer