Converting Trello JSON to SQL Server

Uli Bethke JSON, SQL

In this guide we will show you how to process Trello JSON files with the enterprise version Flexter and convert it to SQL Server.

Trello

Trello is a web-based project management application originally made by Fog Creek Software in 2011, that was spun out to form the basis of a separate company in 2014 and later sold to Atlassian in January 2017.

SQL Server

Microsoft SQL Server is a relational database management system developed by Microsoft. As a database server, it is a software product with the primary function of storing and retrieving data as requested by other software applications—which may run either on the same computer or on another computer across a network (including the Internet).

Setting up SQL Server

  • First we connect to the server through SSMS

  • Then we create a new Database

  • We name our new DB ‘flexter’

  • Then we go to Secutity under Databases and me make a New Login

  • We select SQL Server authentication and put our Login name and Password. Under ‘Default Database’ we select ‘flexter’

  • Then under ‘User Mapping’ we mark ‘flexter’ and ‘db_owner’ and click OK

  • And now we can start processing the file

Processing Trello JSON file

We will be using the Docker Version of Enterprise Flexter on Localhost.

  • We run docker with the below command and create a container that will be destroyed when we exit it
  • Next we generate the Logical Schema ID
  • We now extract our data to SQL Server
  • And now we can see our data

Conclusion

In this post, we have shown you how to convert complex JSON to CSV and then upload them to MS SQL Server.

You can also use the free version of Flexter to convert your JSON files to text and load them to SQL Server.

If you are interested in a downloadable trial version of Flexter please reach out.

 

In this video we show how you can use the free version of Flexter to convert Trello JSON to SQL Server

About the author

Uli Bethke LinkedIn Profile

Uli has 18 years’ hands on experience as a consultant, architect, and manager in the data industry. He frequently speaks at conferences. Uli has architected and delivered data warehouses in Europe, North America, and South East Asia. He is a traveler between the worlds of traditional data warehousing and big data technologies.

Uli is a regular contributor to blogs and books, holds an Oracle ACE award, and chairs the the Hadoop User Group Ireland. He is also a co-founder and VP of the Irish chapter of DAMA, a non for profit global data management organization. He has co-founded the Irish Oracle Big Data User Group.