Your Data the Right Way
Our Specialty
ONRData specializes in preparing your data for use with your analytics tools of choice.
We acquire your data using Structured Query Language (SQL) through direct connections to databases when available, system vendors' Application Programming Interfaces (APIs), and even file feeds or shared spreadsheets.
We design, deploy, and can host data marts, data warehouses, and data lakes using surprisingly affordable cloud services that can scale from daily departmental reports to enterprise dashboards summarizing thousands of transactions from multiple sources in nearly real time.
Our Favorite Projects
ONRData loves working with customers who feel stuck and are thinking to themselves, "I can't get there from here."
Do any of these describe your situation?
You pay licensing for an expensive reporting or analytics tool that you purchased based on advertised data connectors that turned out to be vaporware, badly broken, or otherwise unsuitable for the task at hand
You let an internal team select a NoSQL database because all the cool kids were doing it, and now your simplest data requests tie up your developers for days, and adding new features without bringing down the house of cards is out of the question
The opinionated Data Base Administrator (DBA) who handled your data needs for decades has moved on, and you cannot find anyone willing to maintain the accumulated body of code that is critical to your operations
We have countless other examples where we have applied our Data Best Practices to dig an organization out of what looks like a hopeless mess. You are not alone.
Please contact Mike Organek, morganek@onrdata.com, so we can talk about how to dig you out from under what might appear to be a hopeless situation.
Our Stack
ONRData recommends Open Source Software (OSS) to minimize licensing and other costs of executing the data flows that we build.
PostgreSQL is our Relational Data Base Management System (RDBMS) of choice for its proven history, robust SQL dialect, and wide availability from cloud providers
Python is our scripting language of choice for its ease of use, broad base of developers skilled in Python programming, rich ecosystem of libraries, and the ubiquity of Python learning resources on the web
We pride ourselves in our SQL competence outside the PostgreSQL world and are fluent with MySQL, Microsoft SQL Server, Oracle, IBM DB2, AWS Athena, Redshift, and Netezza SQL dialects