Search Results for "excel data mapping"

GeoTools is an open source (LGPL) Java code library which provides standards compliant methods for the manipulation of geospatial data. GeoTools is an Open Source Geospatial Foundation project. The GeoTools library data structures are based on Open Geospatial Consortium (OGC) specifications.

The Moqui Ecosystem is a series of open source components for enterprise applications all built on a common framework (Moqui Framework) written in Java and Groovy. The components include tools that plug in to the framework, business artifacts, and applications. Some of the popular tool plug ins include ElasticSearch, Apache FOP, Apache Camel, OrientDB, and Hazelcast. The business artifacts later includes a universal data model (mantle-udm), service library (mantle-usl), reusable...

The purpose of GeoRaptor project is to extend Oracle SQL Developer with additional functionality for database administrators or developers working with Oracle Spatial data. Dear Users, A port to version 4.x of SQL Developer is being attempted. It is not simple due to the lack of development resources. Please keep using GeoRaptor with SQL Developer 3.x until the new version is available. Thanks. Simon Greener

ERMaster is Eclipse plug-in to make ER diagram. Functionally, Import from data base, Making of table definition book on Excel, Image output, DDL output, etc. are being offered.

Please leave a review or suggest improvements. Source Code on GIT : https://github.com/milind-brahme/query-light Query Light is a lightweight oracle client based on jdbc. Application has moderate sql editing capabilities. It provides basic querying and data retrieval functions. Query light is ideal for working on read only environments. Latest Update and Fixes Added ability to write xlsx in new office xlsx format. Added ability to view code with F4. Added additional describe...

Adele was developed to simplify the daily work with data. Use it as a swiss knife to fill the gap between your work with spreadsheet application like MS Excel and enterprise servers like SAP ERP. Specialized tools like Rapid Miner, KNIME or similiary stuff should not be replaced. But Adele is designed for business people working with spreadsheet applications to analyse their data.

Mar 2025 - Project moved to Github: https://github.com/symbolthree/exzellenz EXZELLENZ is a pure-Java program to manipulate table data in Oracle database through Microsoft Excel file (in xls and xlsx formats). Using Apache POI and JDBC API, this program can be used to download, insert, update, and delete data in database tables. It does not use any Office VBA, so you don't need to change the Excel security settings, and no need to worry the 32/64bit compatibility. ...

Now stored at https://github.com/gregorydgraham/DBvolution Available from Maven Central: nz.co.gregs.dbvolution Makes relational data easy and fast to use with semantic annotations and encapsulated datatypes. Simple declaration of a DB table: @DBTableName("mytable") public class MyTable extends DBRow { @DBColumn("numeric_code") @DBForeignKey(Code.class) private DBNumber numericCode = new DBNumber(); @DBColumn("uid_mytable") @DBPrimaryKey @DBAutoIncrement private...

Avicenna is an application for visualizing location data stored in excel or .csv table files on a map or in a table view. It provides several export functions (such as single pictures, database dumps and even a HTML-export that enables you to use Avicenna on your website). It was developed as part of the course "Techniken der Projektentwicklung" in summer semester 2012 at the University of Bielefeld by Team 2 and is licensed under the GNU Affero General Public License version 3. ...

A database editor, suitable as front-end for all your relational databases. Connects to Oracle, DB2, MySQL and many other databases. Used to easily query, update and administer your database, create reports and synchronize data.

The “RDB2RDF Mapper” is a Java based software desktop application which allows a user to create a mapping file between a relational database and an RDFS/OWL ontology via a graphical user interface. This project is ANDS-funded.

Apatar is an open source Extract, Transform, and Load (ETL) project. Modular architecture delivers 1. Visual job designer/mapping 2. Connectivity to all major data sources 3. Flexible Deployment Options (GUI, or server engine with JVM, or embedded).

Csvtosql is a library and tool to convert any CSV-based data. It accepts multiple data formats (such as CSV, Excel, or arrays), converts it into SQL statements, and writes the data back in multiple formats (textfile, database).

dbUPLoader is a tool to import data from csv or MS-Excel files into a database. You can distribute data across several tables, create relationships between imported data and integrate sub queries to reference existing data.

TeNeM (Telecommunications Network Model) is a PostgreSQL schema with PL/pgSQL functions and triggers intended to make with a fiber optic network management. It is also a GIS JUMP plug-in to edit and visualize the data. PostGIS is used to extend Postgre.

Designed to collect fisheries data linked to GPS coordinates from small fixed wing aircraft. SQL database runs on WinCE, Palm PDA & other platforms. Program was written using SuperWaba: a robust java-like development environment for handheld devices.

deegree is a Java framework for geospatial software based on the specifications of the OpenGIS Consortium and the ISO. The focus is based on the realisation of OGC specified web services. It is developed in cooperation between lat/lon and the University of Bonn.

This simple java-based web application lets you access from Excel real-time data in any database via HTTP+JDBC by utilizing the Excel "Web Query" feature.

This program converts, compares, merges, normalizes, and refactors data to and from disparate sources (CSV, Excel, and any JDBC/ODBC database) for use in a Java program.

DataVision is a reporting tool similar to Crystal Reports. DV supports many data sources (JDBC, files) and many output formats (HTML, XML, PDF, LaTeX, Excel, delimited files, DocBook). DV includes a GUI editor. DV is embeddable. Reports are XML-based.

TSADOM is The Simplest Access Database Object Mapper you can find. TSADOM contains Factorys converting javaObjects to SQLtables or SQLTables to javaObjects. TSADOM generate itself a data mapping that you can overload.

TimeMap is a mature, Java temporal web mapping/animation application. Use as a standalone web site or CD-ROM app, or as a sophisticated client-server system using an XML or SQL metadata directory to source distributed, incrementally-loaded spatial data.

XB-exby-eXcelBuilder is a web app to select/format data into tabular or crosstab format, then download to a *.xls file. It is meant to be a lightweight bridge between raw data and a spreadsheet, with simple options for selection/layout of data.

QExcel Converter SQL QT4, Import xml excel/openoffice 2003 format, sqlite3 sql text/binary, edit table and export to various Format, Pdf XSL format objects Apache fop JAVA(XSL-FO), XML/XSLT , excel, SQL text sqlite3 dump file and MYSQL SQL to XML/XSL.

AJAX JDBC ResultSet in Javascript. Uses XMLHTTP to send xml server data to a web browser HTML form with no refresh, reload or submit (like Google Suggest). Data can be SQL, object relational map (like Hibernate), XML, other mapping (like SOAP)