Search Results for "data access layer"

...It offers a privacy-focused alternative to mainstream cloud-based productivity tools, enabling users to create, edit, and share documents securely without compromising data privacy. All content is encrypted client-side, ensuring that only authorized users can access the information. CryptPad supports various applications, including rich text documents, spreadsheets, presentations, code editing, kanban boards, polls, and whiteboards, facilitating real-time collaboration among teams. Users can access CryptPad without creating an account, and the platform also offers self-hosting options for organizations seeking full control over their data.

NocoDB is an open source #NoCode platform that turns any database into a smart spreadsheet. It is free & self-hostable. Let your imagination be thy limit. Create unlimited grid view, gallery view, form view from your own data. Search, sort, filter columns and rows with ultra ease. Collaborate just like spreadsheets. Invite your team with fine-grained Access Control. Share views publicly and also with password protection. Build automation with you favorite apps: Microsoft Teams Slack, Discord, Whatsapp, Twilio, Email & SMS.

gspread is a Python API for Google Sheets. A service account is a special type of Google account intended to represent a non-human user that needs to authenticate and be authorized to access data in Google APIs [sic]. Since it’s a separate account, by default it does not have access to any spreadsheet until you share it with this account. Just like any other Google account. To access spreadsheets via Google Sheets API you need to authenticate and authorize your application. Older versions of gspread have used oauth2client. ...

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...

Pyspread is a non-traditional spreadsheet application that is based on and written in the programming language Python. The goal of pyspread is to be the most pythonic spreadsheet. Pyspread expects Python expressions in its grid cells, which makes a spreadsheet specific language obsolete. Each cell returns a Python object that can be accessed from other cells. These objects can represent anything including lists or matrices. Dependencies + Python (>=2.7, <3.0) + numpy...

The PalOOCa Project offers a fast, flexible and intuitive Office-based Business Intelligence solution based on Jedox. It provides an extension for OpenOffice.org Calc which allows both, read and write, access to data from within the Jedox OLAP Server via Calc. If used together with the Open Source Jedox/Palo OLAP Server it completes the Open Source MOLAP-Stack for Business Intelligence. Additionally to Jedox OLAP it is also (read-only) compatible to (almost) all OLAP servers supporting XMLA. Intended audiences are: - scientific research & teaching - financial analysis & controlling Consult the FAQ in the Wiki.

jFox Trading Journal is software developed mainly for currency traders,it provides advanced data analysis to improve traders ability to reach higher profits and eliminate losses.jFox keeps your data in one place.To access or modify any of your data jFox provide simple user friendly GUI.By generating graphs and statistics automaticly,user only needs to provide his data to have full overview over his trades and trading performance.

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.