Database Interfaces

Flow software is purpose-built to move data from source to destination. This often

involves getting data out of a database, or getting data into a database. To achieve

this, Flow includes driver-level support for many database platforms, from MS SQL

and Oracle through to OLEDB and ODBC.

 

The database drivers are integrated with Flow Designer, so that most database

transactions can be defined by dragging table and column references from the

on-screen display of the underlying database structure.

 

Database definitions are saved into your Flow configuration. Each definition can

be retrieved for further editing, and to preview extracted data. Typically the

definition will be used in conjunction with other Flow components to build and run

an automated process that reads or updates the corresponding database.

 

Flow Designer supports single or multi-table database definitions, and the usual

SQL concepts of joining, selecting, grouping, and sorting. Flow database sources

feed directly into Flow Maps, and Flow Custom Scripts, to open up a rich

programming environment for further manipulation of data.

 

Use Flow to create read/write interfaces to a variety of database platforms.

 

If you have any specific queries on database interfaces ask our experienced team and other Flow users in the Flow Community Forum. Sign up to become a Forum member here http://www.flowsoftware.co.nz/support/sign-up

Follow Flow today on

 

Linkedin: http://www.linkedin.com/company/flow-software-limited

Facebook: https://www.facebook.com/flowsoftwarenz

Twitter: https://twitter.com/FlowSoftware

 
 

Browse Articles

101 Uses for Flow

Topics: 10

B2BG

Topics: 10

Flow Software

Topics: 46

Integration

Topics: 39

 

Contact us

Contact us

Contact us about Integration and eCommerce EDI and we will respond ASAP!... Learn more

Flow Integration

Flow Integration

Use Flow as an integration tool to transfer data between your line-of-business applications... Learn more

Flow EDI

Flow EDI

Flow provides you the capability to trade electronically with your trading partners... Learn more