datasqill /ˈdeɪtə skɪl/ is a lightweight data transformation solution for data integration, data migration and data warehousing. It is based on modern modular architecture and implements the concepts of In-Database Execution and Transformation Development with SQL.
In contrast to other ETL Solutions on the market, datasqill executes transformations directly in the environment where data is stored. This leads to higher performance, flexibility and allows processing larger amounts of data without moving them through the network. datasqill helps customers to get the best out of their data storage solutions and brings it to the next level with smart automation and integration features. datasqill is an ideal ELT / ETL solution for In-Memory databases, databases In the Cloud as well as Big Data Integration.
Request a DemoSQL is a universal interface language for databases and Hadoop (SQL-on-Hadoop). SQL can be used in all project stages from prototyping to implementation thus making development process more streamlined, agile and debugging process more transparent as the code is directly executable.
Transformations get executed directly in the environment where data is stored, which allows using datasqill for performant and transparent data processing for ELT and ETL Scenarios. Resources of respective databases are optimally used and new features like In-Memory are seamlessly supported.
datasqill identifies dependencies between transformations based on the metadata and executes them in a correct order without needing to create special job nets thus saving developers effort and minimizing mistakes. Historical execution statistics are used for optimization of the future runs.
datasqill provides modules for different use cases, amongst them Insert, Merge, Flat Files Handling, Web Services Communication, Integration with Reporting Tools and External Schedulers. Custom modules can be built using generic or database-native technologies (Java, PL/SQL, Shell-Scripting, Lua, PL/pgSQL) and seamlessly integrated.
Out-of-the-Box Solution for technical and business data historization (Bitemporal Data Historization) for databases allows efficient Data Management for scenarios like Slowly Changing Dimensions (SCD2), Data Staging and maintaining mapping tables in Data Warehousing without writing a single line of code.
The licensing model is based on the metrics like # of environments, # of transformations running daily, amount of transformed data etc. These can be flexibly combined to fairly reflect actual usage of datasqill. We also provide some consulting along with each license to ensure that customers get the best of their datasqill installation.
datasqill allows flexible scheduled execution of transformation batches while considering inter-batch dependencies. Monitoring views provide visual insights into running batches and give operators control over executed processes.
datasqill is the ideal tool for implementation, execution and monitoring of ELTs and ETLs for Data Warehousing and Business Intelligence, staging source systems data, loading 3NF cores, Star-Schemas, Data Vaults and communication with reporting systems.
Data Analysts can develop and run their SQL scripts with datasqill without a need to learn and understand yet-another-ETL-tool. Integration with reporting and analysis systems like R, Tableau or Cognos is seamless and opens doors for deeper data-dives.
datasqill allows seamless control over transformations running In-the-Cloud and On-Premises as well as communication with Web Services, so that the customers have their transformation landscape under control disregarding of its distribution.
Data Cleansing for operational processes like address cleansing for CRM, communication with public Web Services for data validation or data enrichment e.g. actual exchange rates, stocks information or weather is easily implementable with datasqill.
Data Transformation and Data Preparation for migration from legacy into new systems is easily implementable with datasqill. Data can be extracted from the legacy system, cleansed, transformed, mapped and populated directly into the new system or exported as a flat file.
datasqill runs native transformations in database with SQL or database-native scripting (PL/SQL, Lua), thus eliminating unnecessary layer in form of ETL application server and utilizing natural power of In-Memory Databases for transformations.
datasqill was with by SoftQuadrat GmbH in Germany
We would be glad to make a free demo for you to show how datasqill can improve your data transformation processes!
We are also interested in getting in contact with consulting companies that find datasqill attractive for their customers.
contactdatasqill.de
Tel.: +49 8095 875927