A data transformation tool that is Powerful. Visual. Fast.
- Do you have data in multiple databases and files that you need to combine?
- Do you need to understand data formats and modify them?
- Are you tired of using a database query tool to write SQL every time you want to get at the data?
Datamartist is a desktop data transformation tool that gives you a data scratchpad to get at your data
Explore data integration strategies and test transforms to be used in your data integration tools
Use simple but powerful transforms to do the data mapping you need.
Export your results easily into files, or database tables for use in data analysis tools.
Convert and Clean data quickly
- Parse text fields using familiar spreadsheet functions,
- Calculate new columns easily- see the results on millions of rows instantly
- Combine data of different types from multiple sources and apply the calculation needed.
Data type flexibility allows multiple data sources to be combined
Data profiling lets you see the data at a glance
Browse millions of rows, get at your data.
Create database queries with blocks and connectors
Easily combine, filter and join database tables
Pull data from Everywhere
- Import/Export natively with
- SQL Server
- Oracle
- MySQL
- ODBC
- MS Access
- Excel Spreadsheets
- Delimited text files including CSV data.
- Browse the Datamartist documentation.
- Compare Datamartist functionality to spreadsheets and databases.
- Datamartist at Democamp Toronto.
- Datamartist at the Financial Technology Show.