For people that deal with data. A collection of utility applications that use DataPowerTools to do some cool stuff. (And more coming soon!!)
DataToolChain is built with WPF on .NET 7. You can download and run the latest binaries from the Releases page. You may need to install the .NET 7 Runtimes available from Microsoft's website.
Upload data from multiple sources, including Excel, CSV, and more to SQL server. With data-fitting transformations and better error messages.
- Enter SQL Server credentials and database information
- Select files to upload by clicking "Browse..."
- Set options or leave them as default
- Click "GO"!
Destination MS SQL Server server, database, and credentials (if using SQL server authentication). Cloud auth coming soon.
If entered in left-hand panel, all data will upload to this table. Alternatively can leave this blank and upload to specific tables per file.
If no table names are specified, data will upload to table of the same name as the file name minus extenson.
You can easily copy/paste JSON to allow for saving and storing uploader configuration.
- Apply Default Transform Group - gathers SQL schema information and attempts to transform any dates, numbers, bit values e.g. (Y/N), so that it will be able to upload to SQL server.
- Truncate Tables First - clears data from all tables used by executing a truncate table command.
- Use Ordinals - Normally the uploader will attempt to match by column name but use ordinals will override to upload based on column index instead.
- Bulk Copy Rows per batch - Number of rows per batch to use for SQLBulkCopy protocol.
Extracts formulas from given excel sheets.
- Select files to parse
- Click "GO"!
- Output is tab-separated and can be copied directly into Excel
This tool moves all vLookups in an Excel workbook into a sheet called "__data". This sheet can then be pasted as values to avoid performance issues with vLookups.
A collection of handy string operations. String together IN statements in SQL, or quickly sort or format items on the fly.
- Comma-separated list to vertical list
- Distinct
- Escape Regex
- Escape SQL String
- Format JSON
- Generalize Regex - use ^^^ to enclose groups, and ___ to indicate a wildcard
- NULLIF
- Params to Tabs
- Smart NULLIF
- Sort
- Sort by Length
- SQL Columns to DECLARE statement
- Sql Input Params Into Declarations
- Tabs to params
- Tabs to rows
- Tabs to SQL Columns
- Trim
- Unescape regex
- Vertical list to comma-separated list
- Vertical list to double quoted, comma-separated list
- Vertical list to single quoted, comma-separated list
- Vertical list to SQL literal string
- Vertical list to SQL UNION ALL
- Vertical list to SQL UNIONS
- Parse hours - parses any hour ranges in the text i.e. 1:30am-3pm. Great for parsing time sheets.
- NEW! UnPivot table CSV - unpivots 2-axis matrices into a 3-column table
- NEW! Create Table from CSV - fits csv data into an appropriate CREATE TABLE sql statement
- NEW! Generate SQL inserts from CSV - generates SQL insert statements from csv data
- NEW! Generate JSON from CSV - fits csv data into a json object
- NEW! Generate SQL inserts from JSON - generates SQL insert statements from an array of json objects
- NEW! Generate CSV from JSON
A high performance streaming implementation of outputting a SQL query to a comma-separated values (.csv) file using DataPowerTools. Great for outputting millions or billions of rows to a csv file without using SSMS. Also faster than SSMS or any other tool we've tested.
Experiment with JUST transforms for querying and transforming JSON data (similar to XSLT).
More information here: https://github.com/WorkMaze/JUST.net