PC SOFT

ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Home | Sign in | English EN
  • 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/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
Others
Stored procedures
Analysis: Import files into the analysis (external database, HFSQL files, etc.)
Overview
WINDEV and WEBDEV allow you to easily handle external databases (Oracle, SQL Server, Access, etc.) via 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. For more details, see Accessing the databases.
Remarks:
  • You can also convert only data in a specific 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 HFSQL Classic analysis.
    • 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" tab, in the "Creation" group, expand "Import" and select "Import file/table descriptions...". The data file import wizard starts.
  3. Select the desired 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 through programming.
    • Specify the parameters of the connection if necessary: data server, user and password, database, connection name, etc.
    • Specify the data access mode. You can:
      • access the data in its current format directly. Only the description of the tables is imported into the analysis. No conversion is required.
      • convert the data to the HFSQL Classic.
    • Select the tables (files) to import.
  5. If you want to import HFSQL Classic data files:
    • Select the desired HFSQL Classic data file (.FIC extension).
    • 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:
    • 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.
Remarks:
  • Versions 27 and later
    To import an HFSQL classic file into an analysis, you can simply drag the file from the Windows File Explorer and drop it onto the analysis editor. The import wizard starts automatically.
    New in version 27
    To import an HFSQL classic file into an analysis, you can simply drag the file from the Windows File Explorer and drop it onto the analysis editor. The import wizard starts automatically.
    To import an HFSQL classic file into an analysis, you can simply drag the file from the Windows File Explorer and drop it onto the analysis editor. The import wizard starts automatically.
  • 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