File-based data - Insert JSON data in SQL-Database

Overview

This Scenario describes step by step how JSON-data can be inserted into an SQL database with the SMARTUNIFIER.

Scenario Overview

Prerequisite

JSON-file

{
 "equipmentId": "Equipment_A1234",
 "orderNr": "Order_000101",
 "materialNr": "A1C55100",
 "quality": "IO"
}

SQL-Server Database

Create Database Command: CREATE DATABASE unifier

Create Schema Command: CREATE SCHEMA dbo

Create Table Command: create table dbo.SU_DEMO_UC1_TABLE(EQUIPMENT_ID varchar(max), ORDER_NR varchar(max), MATERIAL_NR varchar(max), QUALITY varchar(max))

Or any other SQL Database supported by SMARTUNIFIER.