#FAQ: 10135-EN, Date: 05/22/2009

How to access, export or import NewWayService 4 data ?

The information in this article applies to :
NewWayService 4.x (English)
NewWayService 4.x (French)


Data Import/Export:
A powerful data import/export utility is included with NewWayService 4. To run this utility, from the Windows "Start" menu, select "Programs | NewWayService 4 | Import-Export utility". This utility (that uses the ADO technology) can access most on the databases available on the market. This utility also, allows you to:

- Use scripts (Object Pascal language) to give you more flexibility when importing or exporting data (ex.: data filtering when importing or exporting data, concatenate of format fields, etc.).

- Save your import/export parameters for later use.

- Automatically run data import or data export (for example, over the night) with the help of a schedule utility software such as the Windows schedule utility.

Refer to the data import/export utility documentation for more information. Note that some tutorials are also available in the documentation.

Exporting reports:
All NewWayService 4 reports can be exported in several file formats such as Excel files. Refer to the documents NewWayService 4 user's guide and Reports generator for NewWayService 4 guide included with NewWayService 4 to know how to export reports and/or create reports for data exportation using the reports generator included with NewWayService 4.

Data access:
NewWayService 4 is using the database Firebird 2.1 to store its data. Firebird is a relational database that can be installed on Windows, Linux, Solaris and other platforms.

Using Firebird with NewWayService 4 gives users a great reliability and stability (relational database), a low licensing cost (Firebird is free, only NewWayService 4 licenses must be bought) without forgetting that Firebird can be installed on the platform of your choice (Windows, Linux, Solaris and more).

Several application software or programming languages can access Firebird databases natively while other must use other way such as an ODBC driver.

NewWayService 4 access the Firebird database natively. No ODBC driver is necessary to NewWayService 4 to access the database. On the other hand if you want to access NewWayService 4 database from other software or reports generators (For example: Ms Access, Excel, Crystal reports, etc.) and these one don't support Firebird access natively, the best way is to use an ODBC driver for Firebird.

To access the NewWayService 4 database from your own custom software, the programming language you currently use can perhaps access Firebird databases natively. If not, you can access the database by using an ODBC driver for Firebird.


To simply import or export NewWayService 4 data, the use of the data import/export utility included with NewWayService 4 is the easiest and recommended way. Also as mentioned above, all reports can be exported in several file formats.

However, if you want to access NewWayService 4 database from other applications, an ODBC driver for Firebird must be used (unless you can access database from a software or a programming language which can access Firebird databases natively).

No ODBC driver is included with NewWayService 4 since this one does not need it. However several manufacturers developed some that are available for free or at a low cost.

Here are some Web sites of manufacturers of ODBC drivers for Firebird (Note that this list is not exhaustive and is available only on a purely informative basis. OroLogic Inc is not associated to any of the manufacturers enumerated below):

Firebird ODBC Driver => http://www.firebirdsql.org
Easysoft ODBC-Firebird Driver => http://www.easysoft.com

Some hints on the choice and the configuration of an ODBC driver:

- Be sure that the ODBC driver is compatible with Firebird 2.1.

- When you configure a connection using your ODBC driver, ensure that you set the following values for the following parameters:

Client: C:\Program Files\Firebird\Firebird_2_1\bin\fbclient.dll
Default Character Set: ISO8859_1
SQL Dialect: 3

Here is a configuration example of the driver "Firebird ODBC Driver":



Please note that OroLogic Inc. does not provide any support on ODBC drivers or programming languages used to access NewWayService 4 database. Refer to the documentation of your ODBC driver, your programming language or Firebird to know how to configure those to access NewWayService 4 database. Also note that accessing NewWayService 4 database from a programming language, other software, ODBC drivers or any other ways is at your own risks.

© 1996-2012 OroLogic Inc.