How to transfer the Data in Azure Data Catalog to another Data Catalog Platform?

Mohammad Shah 0

Since Azure Data Catalog will be decommissioned, is there a way or procedure to transfer all the data inventories that have been created in Azure Data Catalog to another Data Cataloging platform?

PRADEEPCHEEKATLA-MSFT 77,081 Reputation points Microsoft Employee

2023-05-17T10:26:31.75+00:00

@Mohammad Shah - We received your feedback that the answer provided on the thread was not helpful.

Kindly let us know what we could have done better to improve the answer and make your engagement experience good. We are here to help you and strive to make your experience better and greatly value your feedback.

I have provided a detailed answer which has clear steps for which you are looking for. If you wish, you may re-surveying/rating for the engagement you received on the thread. Your feedback is very important to us.

Looking forward to you reply. Much appreciate your feedback!

Regards,

PRADEEPCHEEKATLA-MSFT

1 answer

PRADEEPCHEEKATLA-MSFT 77,081 Reputation points Microsoft Employee

2023-05-16T05:47:15.2666667+00:00

@Mohammad Shah - Thanks for the question and using MS Q&A platform.

As I understand your question, you want to transer the Data in Azure Data Catalog to Microsoft Purview. In case, if you are ask is different please do let me know.

The document shows you how to do the migration from Azure Data Catalog to Microsoft Purview: Migrate from Azure Data Catalog to Microsoft Purview.

Hope this helps. Do let us know if you any further queries.

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.
Please sign in to rate this answer.
Mohammad Shah 0 Reputation points

2023-05-16T08:00:40.4633333+00:00

Microsoft Purview is in the question but what if someone wanted to move data from Azure Data catalog to let's say, Collibra?

PRADEEPCHEEKATLA-MSFT 77,081 Reputation points Microsoft Employee

2023-05-16T08:06:03.7366667+00:00

@Mohammad Shah - Do you mean you want to move data from Azure Data Catalog to Collibra???

In order to assist you better, could you please share more details on your requirement?

Mohammad Shah 0 Reputation points

2023-05-16T09:11:17.0333333+00:00

Yes, for example, if we want to move all the data present in Azure Data Catalog to Collibra, what migration support can Microsoft offer?

PRADEEPCHEEKATLA-MSFT 77,081 Reputation points Microsoft Employee

2023-05-16T09:32:39.8933333+00:00

Microsoft does not offer a specific migration support for moving data from Azure Data Catalog to Collibra. However, there are several options available for migrating the data:

Export the metadata from Azure Data Catalog: You can export the metadata from Azure Data Catalog by using the Azure Data Catalog REST API or the Azure Data Catalog PowerShell cmdlets. This will create a JSON file that contains the metadata for all the assets in your Azure Data Catalog. You can then use this file to import the metadata into Collibra.

Use a third-party migration tool: There are several third-party migration tools available that can help you migrate data from Azure Data Catalog to Collibra. These tools can automate the migration process and ensure that the data is migrated accurately.

Manual migration: You can manually migrate the data from Azure Data Catalog to Collibra by recreating the metadata in Collibra. This can be a time-consuming process, but it ensures that the data is migrated accurately.

It's important to note that the metadata in Azure Data Catalog may contain sensitive information, such as connection strings and credentials. You should ensure that you have the necessary permissions to export and import the metadata, and that you take appropriate measures to protect the sensitive information.

I hope this helps! Let me know if you have any further questions.

Mohammad Shah 0 Reputation points

2023-05-16T09:59:59.8733333+00:00

Can you tell me more about the Azure Data Catalog REST API or the Azure Data Catalog PowerShell cmdlets? Where and how can I access these?

PRADEEPCHEEKATLA-MSFT 77,081 Reputation points Microsoft Employee

2023-05-17T03:36:40.51+00:00

@Mohammad Shah - Apologize, there is no powershell or cli commands available for Azure Data Catalog. Here are the articles Azure Data Catalog REST API.

Azure Data Catalog REST API reference

Hope this helps. Do let us know if you any further queries.

PRADEEPCHEEKATLA-MSFT 77,081 Reputation points Microsoft Employee

2023-05-19T07:10:41.74+00:00

@Mohammad Shah - 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. And, if you have any further query do let us know.
Sign in to comment