Unable to use DMT.

[jenkins123]

I have downloaded the data migration tool on Mac machine, and tried to execute the dmt.
but I am unable to execute the dmt from terminal, I see error

sudo: dmt: command not found

I tried setting up the dmt file in the path , still no use. Not sure what need to be done to run this tool.

[philnach]

@jenkins123 thank you for reaching out have you seen this part of the README: https://github.com/AzureCosmosDB/data-migration-desktop-tool#using-the-command-line.

I just double checked on macOS Sequoia that the current release of dmt works. Here's output from my terminal:

If you are running the release out of your Downloads folder make sure:

1. The file has execute permissions chmod +x dmt
2. The file isn't being blocked by macOS Gatekeeper: Open a Mac app from an unidentified developer or from a command line: [Gatekeeper Exception command line.md]

[jenkins123]

Hi Mr Phil, Thank you for the response, yeah I figured it out that it was a permissions issue and could run the tool.
Now I see a different problem connecting to cosmos db .
Using Cosmos-nosql Source
Using JSON Sink
fail: CosmosDataSourceExtension[0]
Failed to connect to CosmosDB. Please check your connection settings and try again.
Microsoft.Azure.Cosmos.CosmosException : Response status code does not indicate success: NotFound (404); Substatus: 0; ActivityId: 00000000-0000-0000-0000-000000000000; Reason: (
RequestUri:xxxxx
Any pointers if there is any thing I am missing here.

the config I am using is

{
"Source": "cosmos-nosql",
"Sink": "json",
"SourceSettings": {

   "ConnectionString": "AccountEndpoint=abcd.com:443/;AccountKey=xxxx===",
  "Database":"osco-perf",
  "Container":"order",
  "IncludeMetadataFields": false

},
"SinkSettings":
{
"FilePath": "/Users/someuser/Downloads/Backup/xyz.json",
"Indented": true
}
}

[philnach]

Hi, I just confirmed on the same Mac with the latest 2.2.0 release and your settings file that I was able to transfer data from Cosmos DB to JSON. It sounds like perhaps your connection string isn't correct. You can copy the connection string directly from the Settings->Keys section in Azure Cosmos DB account (https://learn.microsoft.com/azure/cosmos-db/nosql/tutorial-dotnet-console-app#create-api-for-nosql-resources).

Can you also check that you can access the database from Azure Portal and view data in the Data Explorer?

[philnach]

@jenkins123, hi wanted to see if copying your connection string directly from the Azure Cosmos DB account was able to resolve your issue. I've spent an extensive amount of time using dmt on macOS this week and it's been working great.