NewWayService 2.x (English)
NewWayService 2.x (French)

Data Import/Export:
A powerful data import/export utility is included with NewWayService 2. To run this utility, from the Windows "Start" menu, select "Programs | NewWayService 2 | 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 online help for more information. Note that some tutorials are also available in the online help.


Exporting reports:
All NewWayService 2 reports can be exported in many file formats such as Excel files. Refer to the NewWayService 2 online help to know how to export reports and/or create reports for data exportation using the reports generator included with NewWayService 2.


Data access:
NewWayService 2 uses the InterBase 6 "Open Source" version database to store its data. InterBase 6 is a relational database that can be installed on Windows, Linux and Solaris platforms.

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

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

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

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

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

On the other hand if you want to access NewWayService 2 database from other applications, an ODBC driver for InterBase 6 must be used (unless you can access database from a software or a programming language which can access InterBase 6 databases natively).

No ODBC driver is included with NewWayService 2 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 InterBase 6 (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):

Gemini InterBase ODBC Driver => http://www.geocities.com/ibdatabase
Easysoft ODBC-InterBase Driver => http://www.easysoft.com
XTG InterBase 6 ODBC Driver => http://www.xtgsystems.com


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

- Be sure that the ODBC driver is compatible with InterBase 6.

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

Default Character Set: ISO8859_1
SQL Dialect: 3

Information

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