CODEX
Creating a Solution for Database Connections
Using Connections for reliable, efficient, and effective solutions
For a proper data analysis, there needs to be data in a dataset. There are different ways to store data. Using a database is a common solution, and requires a valid connection between app and warehouse or data lake.
MSSQL and MySQL are the two most common variations of databases, both are SQL. There are differences in syntax but both are very similar. Creating a connection to either database removes a layer for efficient analytics by allowing the analytics engine to interface with the database without exporting data from the database and importing to the analytics platform.
Just the Basics
APIs for integration are common. The API is an open source plug-in premade and packaged engine to assist in implementation of a product to allow data to flow directly to the intended analytics engine.
Python can use the mysql.py script. The script contains all the information needed to have a stable connection from the database to the Python engine allowing manipulation in Python on the external SQL database that is providing the data.
