Handling binary data

Foundamentals

In NoSQL datastores binary data is usually being interpreted as a string and so it is handled when pushing it to the target RDBMS by Gluesync data streaming engine. There are chances that you’d like to get a different result when dealing with binary data types so, by defining a specific data type for the field in subject, you can ask Gluesync to convert it into a bite array format that opens up compatibility for a different range of use cases, like:

  • GEOGRAPHY,

  • GEOMETRY,

  • IMAGE,

  • VARBINARY

  • and BINARY data types.

Configuring data type inference for incoming Binary strings

 "entitiesDataTypes": {
    "ENTITY_NAME": {
      "FIELD_NAME" : "BINARY"
    }
  }

By specifying BINARY as a data type will immediately tell Gluesync to infer a different type to the given string.