PC SOFT

WINDEVWEBDEV AND WINDEV MOBILE
ONLINE HELP

Home | Sign in | English UK
  • Overview
  • How to import a data file (or table) into an analysis
  • Prerequisites for converting a data file (or table) from an external database to an HFSQL data file
  • Importing a data file into an analysis
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadApple WatchUniversal Windows 10 AppWindows Mobile
Others
Stored procedures
Handling an external database
Overview
WINDEV, WEBDEV and WINDEV Mobile allow you to easily handle an external database (Oracle, SQL Server, Access, etc.) by using WLanguage functions.
To handle an external database, you must:
  1. Import the files (or tables) from the external database into the analysis. During this import, the data can be:
  2. Generate the analysis.
  3. Handle the imported data files via the WLanguage functions. See Accessing the databases for more details.
Remarks:
  • You also have the ability to convert the data found in a data file with WDConver. To perform this operation, the file description must have been imported into the analysis.
  • The data model editor allows you to perform the following operations:
    • Import a data file from an external database into an analysis in HFSQL Classic format.
    • Import a data file in HFSQL Classic format into a new analysis in HFSQL Classic format.
Remark: From version 19, HFSQL is the new name of HyperFileSQL.
How to import a data file (or table) into an analysis

Prerequisites for converting a data file (or table) from an external database to an HFSQL data file

To perform an import from:You must own:
a database managed by ODBCan ODBC driver
a database managed by OLE DBan OLE DB driver
a database managed with the Native SQL Server ConnectorNative SQL Server Connector (optional module of WINDEV/WEBDEV)
a database managed with the Native Oracle ConnectorNative Oracle Connector (optional module of WINDEV/WEBDEV)
a database managed with the Native AS/400 ConnectorNative AS/400 Connector (optional module of WINDEV/WEBDEV)
a database managed with the Native SQL Azure ConnectorNative SQL Azure Connector (optional module of WINDEV/WEBDEV)
a database managed with the Native MySQL ConnectorNative MySQL Connector (optional module of WINDEV/WEBDEV)
a database managed with the Native Informix ConnectorNative Informix Connector (optional module of WINDEV/WEBDEV)
a database managed with the Native DB2 ConnectorNative DB2 Connector (optional module of WINDEV/WEBDEV)
a database managed with the Native Sybase ConnectorNative Sybase Connector (optional module of WINDEV/WEBDEV)
a database managed with the Native Progress ConnectorNative Progress Connector (optional module of WINDEV/WEBDEV)
a database managed with the Native PostgreSQL ConnectorNative PostgreSQL Connector (optional module of WINDEV/WEBDEV)

Importing a data file into an analysis

To import a data file into an analysis:
  1. In the data model editor, open the analysis where the import must be performed.
  2. On the "Analysis" pane, in the "Creation" group, expand "Import" and select "Import file/table descriptions...". The wizard for importing the data files starts.
  3. Select the requested data source.
  4. If you want to import an external database:
    • For data sources that use a Native Connector, a connection to the external database is automatically established and associated with the data files imported into the analysis. This connection will be used to handle the data files by programming.
    • Specify the parameters of the connection if necessary: data server, user and password, database, connection name, etc.
    • Specify the mode for accessing data. You can:
      • access the data in its current format directly. Only the description of tables is imported into the analysis. No conversion is required.
      • convert the data to the HFSQL Classic format.
    • Select the tables (files) to import.
  5. If you want to import HFSQL Classic data files:
    • Select the data file (.FIC extension) in HFSQL Classic format that must be retrieved.
    • Specify the password of this data file if necessary.
  6. Validate the import. The current analysis is automatically generated.
  7. If the data must be converted to HFSQL Classic format:
    • Specify the creation directory of HFSQL Classic data files.
    • Save (if necessary) the description of the conversion (script). This operation creates a ".WDV" file in the specified directory. This script can be re-used by WDConver.
    • Validate the data conversion.
Remark: From version 19, you can no longer import Hyper File 5.5 data files. This import can only be performed with WINDEV or WEBDEV 18 (or earlier).
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment