SQL – The Key to Timely and Affordable Data

SQL – The Key to Timely and Affordable Data

A problem in the petroleum industry has producers and operators not getting timely data from their LACT, tank, and truck transfers.

Automation and Information – A SQL Success Story

The quicker data is transferred, the faster analytic teams and other stakeholders can uncover mistakes, forecast transaction values, and generate billing.

Flow Data is a systems-integrator and we offer a solution that places SQL at the site, providing dynamic data for:

  • Controlling LACT skid processes
  • Measuring fluid transfers between LACT skid, tanks, and trucks
  • Recording detailed information about all production transactions for Oil & Gas, Water/Wastewater, Agriculture and Irrigation Systems, Industrial, and more

Traditional systems are cumbersome and require trained IT programmers to make simple changes to reports, transactional database lists, or system protocols.

When a client approached us for a solution, they were using a leading, brand name controller. Their frustration stemmed from their inability to get timely transaction data. The system was limited: first, it could only hold 30 transaction records, making it difficult to review historical data for analysis; second, the system used proprietary programming language, which required multiple software interfaces and protocol conversions to retrieve the data; and third, given its proprietary nature, it was complicated and costly to modify.

The SQL Solution

By placing a SQL database at LACT unit, tank battery, or truck transfer site – your data collection possibilities are endless.

Accessing SQL requires only primary query language, which is the fundamental reason this solution has more advantages than most others on the market.

  • Our SQL database holds over 10,000 transaction records, retrievable via a simple SQL data query
  • SQL is not a proprietary language; queries are made by technicians, not IT programmers
  • System data integration is easy; any accounting software that understands SQL can access the database
  • It runs without multiple “translators” – providing access to information on demand

Systems-Integrators Sing SQL’s Praises

The Flow Data SQL solution is managed at the corporate level. The controller system is easily updated using a simple database spreadsheet. Changes are pushed to the site system by a quick configuration, making it easy to manage changes in hauler, producer, driver, production information, and more.

No more mediators! The SQL spreadsheet is queried for data that transfers directly into accounting systems. SQL makes systems-integration:
  • Easier to maintain, change, or configure
  • Manageable by personnel at the corporate level
  • More straightforward, because non-programmers can make changes
  • Relevant, as MS-Excel reports are pulled from the historic OR dynamic detail
Old News is Simply Bad Reporting
Our clients demand better reporting. Obtaining transaction data is complex and involves a lot of manual entry and complicated software programming conversions to get the data to integrate with back-office systems. Integrating both manual and digital data takes a long time to get figures from the field to the corporate office. Plus, missing or suspect data has to be verified before transposing it into reports. Reporting could take up to 30 days following the transaction.
This old process impacts analysts, accountants, and automation technicians in the field. Changes made at the corporate level don’t reach the field quickly because of proprietary programming. Our client consistently had issues with keeping accurate records of current haulers. Changes driven at the Corporate level weren’t making it down to the field system. Field techs were forced to either call the home office to verify the change, or manually enter the information on a paper transaction ticket, where it would later have to be verified by the home office.

Flow Data has been using the SQL solution successfully in the market for many years.  Our patented technology provides transaction data in real time. As petroleum or water transactions, transfer from one owner to another, it digitally records the activity and data in as much detail as you desire, dynamically. For more information, and to see a demonstration, please call us.

The Bottom Line

The chart shown, demonstrates the potential ROI you may see with the Flow Data solution. These figures are conjecture but representative of the savings some of our clients have experienced.

Cost ComparisonPrevious Proprietary SystemFlow Data SQL Solution
System hardware panel$25,000$30,000
Proprietary system program set up costs $5,000--
Flow Data programming support set up--$5,000
Proprietary system reporting integration programming$10,000--
Proprietary programming costs for report changes
4X / year
Proprietary programming costs for protocol changes
6X / year
Write-offs due to manual ticketing errors non-SQL solution
(Single tank battery- annually)
Write-offs due to manual ticketing errors w/SQL system
(Single tank battery- annually)
No manual tickets, with Flow Data’s Panel HMI & SQL database
1X integration setup - from proprietary system to SQL DB --$10,000
SQL DB report changes – costs
(done internally by non-programmer)
SQL DB protocol changes – costs
(done internally by non-programmer)
ROI$85,000 savings in the first year
Do NOT follow this link or you will be banned from the site!