Data Extract Made Easy
dbFunnel makes the task of extracting and sending DB2 data easy from your IBM i.
dbFunnel is a tool that will help save time, money and frustration when dealing with data extraction projects.
How does dbFunnel Work?
Transparent to the user, dbFunnel dynamically creates all the SQL syntax. All the magic is hidden from the user. The user can then concentrate on extracting the data pertinent to the project.
There are 3 easy steps:
1. Configure the Project
A project is a group of extract objects that are executed together. For example - Daily Extract, Monthly Extract or Near Real Time
2. Add the Tasks
Tasks belong to a Project and the objects that are sent to the end point.
3. Add Detailed Extract Definition
The Extract Definition belongs to a Task. This step contains all the details about the actual data being extracted.
What are our customer's saying?
"We have used dbFunnel (formerly known as ERP Explorer) to populate our hosted Data Warehouse for the last 5 years. dbFunnelruns every 5 minutes and loads data from our ERP and WMS. We have been very pleased with the performance and the reliability of the application, and the support has also been great." Joseph Akpovi, CSCP, LBC
Inventory Control Manager
Del Monte Foods, Inc.
"After a recent acquisition, Fiberweb was saddled with the monumental task of quickly extracting data from our legacy ERP to feed consolidated reporting systems for it’s parent company, PGI. What could have taken weeks and months, was done quickly using dbFunnel. Making ongoing changes to add fields and change logic to support business reporting changes often takes less than an hour instead of days"
Sr Systems Analyst
Fiberweb a PGI Company