Help Center> ROMA Connect> FAQs> Data Integration Tasks> Which Types of Data Are Supported by FDI Databases?
View PDF

Which Types of Data Are Supported by FDI Databases?

FDI databases support the following types of data:

  • Kafka: string
  • MySQL: integer, bigint, number, varchar, char, float, date, timestamp, and datetime
  • Oracle: integer, bigint, number, varchar, char, float, date, and timestamp
  • SQL Server: integer, bigint, varchar, char, float, date, datetime, and timestamp

    (Timestamp data is stored in binary format in the SQL Server database.)

  • PostgreSQL: integer, number, varchar, char, float, date, and timestamp
  • MongoDB: integer, double, string, boolean, date, long, object, and array
  • DIS: integer, JSON, arraystring, boolean, long, double, bigdecimal, and date
  • MRS Hive: integer, bigint, string, float, timestamp, varchar, char, and date
  • MRS HBase: string

You are not advised to use varchar, char, and date for the MRS Hive database. If the data source length exceeds the limit, FDI cuts off the excessive the length, which may cause incomplete information.

Parent topic: Data Integration Tasks