Collecting SQL from various databases is often a challenging and time-consuming process since schemas and syntaxes pretty much always vary across different databases. To solve this challenge, we’ve revamped our phData Toolkit CLI automation tooling to include a SQL collection solution that simplifies collecting SQL across databases.
In this blog, we’ll explore this new functionality in greater detail and touch on a few other tools within the phData Toolkit that can help gather and analyze SQL.
What is the SQL Collection Feature?
SQL Collection is a feature of the Data Source Tool within the phData Toolkit CLI to help users automate the collection of SQL across various databases.
What Are the Advantages of Automated SQL Collection?
There are several benefits to automating the SQL collection process, but here are four of the most prominent advantages we’ve seen with our team internally and with our customers:
Time-Saving: Speeds up the process and reduces time on repetitive tasks
Accuracy: Noticeably less human errors
Efficiency: Multi-threaded approach of SQL collection allows one to handle more tasks simultaneously
Consistency: Follows a predefined approach that ensures uniformity in the process
How to Collect SQL Using the Data Source Tool from the phData Toolkit CLI
The phData Toolkit CLI has added functionality allowing efficient SQL collection through the Data Source Tool. This tool provides multi-threaded bulk SQL collection and stores the gathered SQL in a structured and organized output directory.
Collecting the SQL for your database is as easy as a single command:
toolkit ds sql-collect oracle
At the initial release, the supported source database systems are: