Data type conversions between Langstack and MSSQL

Due to limitations on data type conversion between MSSQL and Langstack, not all data types are supported when reading or writing to MSSQL. The two tables below show the level of the supported data conversion for reading and writing to MSSQL, where the supported data types are marked either with the color green or orange, representing the following:

  • Allowed: Marked in green with letter 'A' for 'allowed'. These conversions are allowed and fully supported without any data loss.

  • With Warning: Marked in orange with the letter β€˜W’ for β€˜warning’. These conversions are supported with a potential data loss, row skip or fall back to default value due to overflow. This is caused due to data incompatibility for example, mapping a string value to XML, while the string does not contain a valid XML value, or reading a numerical value from SQL to integer value in Langstack which causes data loss of the decimal data, or can set to default value if the numerical value is larger than the integer limit in Langstack.

  • Blank (white space): Data type conversions that are not supported cause the ETL process to abort on initialization and if the ETL execution log is provided in the ETL template setup, the error message is logged. Users can see the last error message when opening the ETL template setup.

A summary is logged for conversions with β€˜warning’ or β€˜error’ messages.

Data type conversions for Reading from MSSQL

The following table shows the supported data type conversions for reading from MSSQL to Langstack. In the table, the column under β€œFrom” displays the source (MSSQL) data types and the row β€œTo” displays the destination (Langstack) data types.

Data type conversions for Writing to MSSQL

The following table shows the supported data type conversions for writing from Langstack to MSSQL. In the table, the row β€œFrom” displays the source (Langstack) data types and the column under β€œTo” displays the destination (MSSQL) data types.

Special notes on types using MSSQL

MS-SQL column identity:

The identity column identifies a certain row in an MS-SQL table. It is a numeric column that is auto-incremented with integer values when rows are inserted. There are six (6) data types that may be defined for identity columns:

  • Int

  • Bigint

  • Smallint

  • Tinyint

  • Numeric

  • decimal.

If the writer (destination) is MS-SQL, data cannot be written to the identity column and any attempts to write to the identity column will be ignored.

Last updated