Search Results for "pivot"

ClosedXML is a .NET library for creating and manipulating Excel files without requiring Microsoft Excel, designed for easy integration and performance.

...Comes with support for multiple connections, to many different SQL database types, a schema explorer, query history (e.g. lightweight version control), a basic security model, in-browser pivot tables, and more. SQL Explorer values simplicity, intuitive use, unobtrusiveness, stability, and the principle of least surprise. SQL Explorer is inspired by any number of great query and reporting tools out there.

This RAD platform allows to quickly develop web and mobile applications without any coding task. Applications can be developed by simply configuring them through a graphical environment. There is no limit in the complexity of the applications to create, since there is always the chance to include custom scripts made by a developer. The platform supports multiple databases and operating systems, since it has been developed using Java and it provides a rich user interface based on Sencha ExtJS.

https://sourceforge.net/projects/in2sql Video for best usage https://rb.gy/tvl8lk This Excel Addin helps SQL analytic create an Excel report based on ODBC relational data. *Creates table base on data from a relational database *Generate a pivot report using the same external connection (1) *Some ad-hoc tools are available - like "keep only" and "remove only" *you can use the row limit option for exploring the largest dataset *The ODBC connection manager is available *auto-build query tool can create SQL select statement by using different database tables with matching them by column name * creating connections for PowerQuery news and updates -- change list -- v05 beta export tables and SQL to CSV files treat CSV like relational tables -- add Cloud ClickHouse Source resolve the problem with an untrusted source changed Sql Editor fixed behavior for "update rows"

SQLeo is a professional lightweight SQL Query tool that permits to create or display complex sql queries (from OBIEE, Microstrategy, SSRS, Cognos, Hyperion, Pentaho ...) and permits to reverse engineer database models as db designers do. This SQL GUI supports all JDBC drivers: Oracle, MySQL, MSSQL, Firebird, HSQLDB, H2, PostgreSQL, CsvJdbc, SQLite, UCanAccess, MonetDB ... (but MySQL jdbc and CsvJdbc are the only driver included in the package) Can be compared with : FreeQueryBuilder...

The code in this archive represents the final version of EPPlus under LGPL. There will be no more activity here. EPPlus will from version 5 switch license from LGPL to Polyform Noncommercial 1.0.0 license. With the new license EPPlus is still free to use in some cases, but will require a commercial license to be used in a commercial business. Create advanced Excel spreadsheets using .NET, without the need of interop. EPPlus is a .NET library that reads and writes Excel files using the Office...

littletable is a lightweight in-memory data manager of collections of Python objects, providing ORM-like access for querying and joining data using object attributes as pseudo-columns.

ETL Framework is a standalone Extract Transform Load engine written in Java. It includes executables for all major platforms and can be easily integrated into other applications. Key Features: * embeddable, open source and free * fast and scalable * uses target database features to do transformations and loads * manual and automatic data mapping * data streaming * bulk data loads * data quality features using SQL, JavaScript? and regex * data transformations Requirements *...

SQLiteCel is a simple Excel Interface to SQLite designed to help you edit, view and analyze data from SQLite databases.

Dynamic SQL framework eases dynamic SQL generation by providing a convinient Object Model for constructing database indpenedent SQL queries. Current version supports, complex queries, Paging and Cross Tabs (Pivot Tables)

The jibiki plateform is to be used by multilingual dictionary writters to create and publish their XML based dictionary. It supports different lexical architectures (monolingual dictionaries, 1 to 1 or 1 to many dictionary or pivot based dictionaries).