Migration InfluxDB to CrateDB? (outflux-like)

How do we migrate from InfluxDB to CrateDB? Do we have something like outflux (https://docs.timescale.com/latest/tutorials/outflux) ?

1 Like

If we have it please let me know @miguel.arregui … I would love to prepare a migration guide with it :wink:

1 Like

Hola Carlota!

I am going to have a play with InfluxDB and outflux and see.

Best

Hi Miguel, i currently have a project where a competitor is offering influx to the customer. I would like to use CrateDB instead. But what i am missing is the ecosystem around cratedb (like telegraf, kapacitor). Basically i have seen that cratedb can be used as output for telegraf. Can the capacitor also be used. What are the preferred tools for ingesting / transforming data. Also elasticsearch comes with the ELK Stack. Do you have proposals what are the best tools providing a solution with CrateDB ?

1 Like

Hi Michael,

You are open to pretty much use any tool which supports ODBC, JDBC or Postgres Wire Protocol, which is a huge advantage compared to using a proprietary language (Flux) to query your Data.

Typical Tools/Technologies used together with Crate:

  • Kafka, MQTT, Azure Event Hub, …
  • Flink, Spark, Telegraf, …
  • Grafana, PowerBI, Qlik, …
  • Streamsets, NiFi, Node-red, …
1 Like

Hi, all.
Isn’t ODBC/JDBC a bottleneck? For medium-to-large payloads (e.g. more than 10k rows per dataset per second)

That of course always depends on the client implementation (e.g. how much parallelism), but typically not. I don’t have an example ready, but we definitely so multiple 10k or 100ks rows / s with some Spark + JDBC implementation.

Also CrateDB supports all kinds of other drivers / clients (see CrateDB Clients and Tools — CrateDB: Clients and Tools) as well as an http-endpoint (https://crate.io/docs/crate/reference/en/4.6/interfaces/http.html).