Tag Archives: database

Remove CSV text qualifiers within a field using Python

1 May, 2020 · by · in Data architecture, ETL, Programming · Leave a comment

Have you ever tried to import a CSV into a database and found that it won’t load because one of your CSV fields has a text qualifier inside the field itself? In this post I look at how to resolve this issue using a few lines of Python code.

How to forward engineer SQL scripts from Microsoft Visio

22 April, 2020 · by · in Data architecture, How To, System architecture · 1 Comment

Ever wanted to forward engineer a SQL script of DDL statements to automatically generate the tables based on a Visio entity relationship diagram (ERD)? In the steps below, I will explain what you need to do in order to install the Forward Engineer plugin for Microsoft Visio 2010, based on the original work by Alberto Ferrari.