Projects tagged ‘csv’, ‘database’, and ‘java’

Scriptella is an ETL (Extract-Transform-Load) and script execution tool. Its primary focus is simplicity. It doesn't require the user to learn another complex XML-based language to use it, but allows ... [More] the use of SQL or another scripting language suitable for the data source to perform required transformations. Main features: * Simple and minimalistic XML syntax for ETL scripts. * Built-in providers for JDBC, CSV, Text, XML, LDAP, Lucene and Velocity. * Support for many useful JDBC features, e.g. parameters in SQL including file blobs and JDBC escaping. * Easy-to-Use as a standalone tool or Ant task. No deployment/installation required. Easy-To-Run ETL files directly from Java code. * Seamless integration with Java/Java EE and Spring [Less]

Apatar is an open source data integration application to help join your desktop data with the web. Apatar effectively integrates data and applications, and provides visual job designer and mapping ... [More] , joins, filtering, data cleansing and validation capabilities. Connectors include MySQL, PostgreSQL, Oracle, MS SQL, Sybase, FTP, HTTP (POST and GET), SalesForce.Com, SugarCRM, Compiere ERP, Goldmine CRM, XML (local and web-based), flat files (CSV, TXT), Webdav, Buzzsaw, LDAP, Amazon, RSS and even Flickr; more connectors are under way. [Less]

benerator is a framework for creating realistic and valid high-volume test data, used for testing (unit/integration/load) and showcase setup. Metadata constraints are imported from systems and/or ... [More] configuration files. Data can be imported from and exported to files and systems, anonymized or generated from scratch. Domain packages provide reusable generators for creating domain-specific data as names and addresses internationalizable in language and region. It is strongly customizable with plugins and configuration options. [Less]

There are many csv-parsers out there. So why another one? Because none of the others did what I needed. So what is special about this csv-to-db utility? I'll tell you. CSV Parser FeaturesExports ... [More] from outlook-addressbook can have carriage-returns in the address (if you entered it that way in outlook). This utility will handle that correctly. It converts a csv-file into a java.sql.ResultSet so you can use it the same as you use a 'select' sql statement Because you might want to make selections on the file, you can put it in a DataBase. Some CSV files have column-names on the first row. These will be used as the metadata for the ResultSet. Internationalization. Different date-formats and decimal points. Not all CSV files use a comma to seperate the fields, sometime tabs are used. This utility can. When you want to put the file into a DataBase, you can configure what the DataBase table will look like. DB Creation Features You can supply a jdbc connection url to use, or use the default Derby. You can use an existing table, or create a new one. You can tell what data-type the fields of the table will be. Many data-types are already there, but you can make your own implementation of the DbType so this utility can handle your database. You can add an extra column enabling you to create a primary key. Some CSV files have column-names on the first row. These will be used as the column-names for the table. Some CSV files don't have column-names on the first row. You can supply the column-names yourself. Some CSV file do have column-names on the first row, but you don't want to use those but supply your own. Also possible. [Less]

Documentation and a download area for Klaro Projects is available on my Personal Website (currently in german language only - sorry folks). Feel free to navigate the source or download the tools. ... [More] The software bundled in Klaro Projects is offered under the New BSD License. [Less]