Our source data is stored in Doris. Can I create a CDM database in Doris and ETL the source data into it?
These are the databases the community supports currently:
- Microsoft SQL Server
- Oracle
- PostgresSql
- Microsoft Parallel Data Warehouse (PDW, a.k.a. Analytics Platform System)
- Amazon Redshift
- Apache Impala
- Google BigQuery
- IBM Netezza
- SQLite
- (DataBricks)Spark
- Snowflake
- Synapse
One option is to ETL your data into the CDM into a Postgres database. Postgres is open-source and many in the community use it in this way.
New databases can be considered, however we need support from members of the community to integrate these things.
@anthonysena / @schuemie do you agree with what I’ve written?
Thanks Erica. We have billions of records in Doris. Can Postgres handle them?