   |
|
Input Tools - Database Query (OLEDb)
The Database Query (OLEDb) Tool is used to create a Task Step that allows the extraction of specific information sets from relational database systems such as ERP, Financial, Accounting, MRP, Production, CRM, HR, Project and Bespoke systems to name but a few.
Once obtained, the information is then available to other Format or Output Steps for manipulation and/or delivery.
The Database Query (OLEDb) Tool has comprehensive support for both modern and legacy platforms supporting both the SQL 89 and SQL 92 ODBC standards and variations thereof
Works with other Tools
These are other Tools that this Tool will interact directly with whether by exposing information to it or consuming information from it.
- Flat File Import Tool
Input Tools - Database Query (OLEDb)
The Database Query (OLEDb) Tool is used to create a Task Step that allows the extraction of specific information sets from relational database systems such as ERP, Financial, Accounting, MRP, Production, CRM, HR, Project and Bespoke systems to name but a few.
Once obtained, the information is then available to other Format or Output Steps for manipulation and/or delivery.
The Database Query (OLEDb) Tool has comprehensive support for both modern and legacy platforms supporting both the SQL 89 and SQL 92 ODBC standards and variations thereof
Works with other Tools
These are other Tools that this Tool will interact directly with whether by exposing information to it or consuming information from it.
- Flat File Import Tool