Open Source Projects

Estimated reading time: 4 minutes

Overview

Interject hosts a variety of open-source projects aimed at providing useful tools for data handling, automation, and database management.

Note: Some of these projects are not actively maintained.


BeetleETL

Beetle is a Python3 package with tools necessary for transferring data from a MongoDB database to a SQL Server Database. A well defined configuration file allows the user to define the exact way data from MongoDB should be transferred to SQL Server, making Beetle a powerful tool for ETL solutions where transferring data from databases is necessary. The package comes equipped with a standalone executable as well as a modular execution setup enabling easy API or custom script integration.

Pypi

Project Repo

Data-Latinizer

This project provides a tool to sanitize data in a database using Latin text. It includes PowerShell scripts to easily execute SQL scripts on a specified database.

To use Data-Latinizer, download or clone the repository, navigate to the Powershell Scripts folder, and run the ExecuteAllSqlScripts.ps1 script, providing your server instance and database details. This script will loop through and execute all SQL files in the project on the given database. If script execution is blocked, the project provides instructions for adjusting the PowerShell execution policy to bypass restrictions.

Project Repo

ScriptMySQLServer

This project includes two PowerShell scripts for automating MySQL server interactions:

ScriptMySQLServer.ps1: Connects to a MySQL server to export stored procedures and functions from databases into individual SQL files, organized by database and object type. It supports exporting from all or specific databases and generates SQL DROP and CREATE statements for each object.

ExecuteSqlScripts.ps1: Executes SQL scripts from a specified folder on a MySQL server. It uses provided credentials and can run in test mode for debugging by printing variable values.

Project Repo

Powershell DB Tools GUI

The Powershell DB Tools GUI is a tool designed for database administrators and developers to simplify the process of scripting out database objects and executing SQL scripts on one or more databases. The program offers a user-friendly interface with two main functionalities: the Script Out DB and Execute SQL Scripts tabs.

Project Repo