Using CrateDB Toolkit to sync MongoDB with CrateDB

CrateDB
19

Hi again,

We used a CrateDB Cloud CRFREE cluster on the destination end, and it works for us with CTK v0.0.36. Please note the ?ssl=true parameter on the CrateDB cluster URL.

alias ctk='uvx --from=cratedb-toolkit[mongodb]==0.0.36 ctk'
ctk load table \
  "mongodb://localhost/test/testdrive" \
  --cluster-url="crate://admin:{redacted}@testcluster.aks1.westeurope.azure.cratedb.net/doc/testdrive?ssl=true"

Please let us know if that works for you, or if you need further assistance.

With kind regards,
Andreas.

NB: When using Docker, this would be the appropriate overlay command for ad hoc use of CrateDB Toolkit v0.0.36, where uvx was used above.

alias ctk='docker run --rm -it --network=bridge "ghcr.io/crate/cratedb-toolkit:0.0.36" ctk'

NB: The other command syntax that goes for MongoDB like /collection?table=collection.table, coming from ingestr, does not fit that interface, i.e. is wrong, so please don’t use it. In the same spirit, we will remove it from the documentation, because it seems not to be ready yet. Sorry for the confusion and thanks for your patience.