Make your Information System compatible with any type of file
Your organization may need to exchange data with third parties (partners, government agencies, customers, suppliers ...) using imposed data formats.
The Stambia connector for files allows to integrate or generate any type of file, whether simple (flat, positional, delimited ...) or complex and composed of hierarchies.The file description is graphical and wizard-assisted.
Writing hierarchical files
Reading hierarchical files
Replication of hierarchical files
Coupled to the Stambia replication component, the connector allows you to replicate a hierarchical model into a standard relational database.
Thus the reading or writing of a flat file is automated and requires no complex development. This component allows you to browse a directory and massively integrate hierarchical files into a relational database. In this case, there is no mapping, thus no development. The replicator is able to create a relational structure from the hierarchical structure of the file and to fill the database with the files that have been found in the folder.
The hierarchical files connector, which is a JDBC driver, can read or write delimited or fixed length files and can manage occurrences inside a same line (variable length of the same type of line).
Once the description of the file has been done, it is possible to perform simple SQL orders to read the file as if it was a compound of multiple tables.