Key features of the Tensei-Data system

In the future, data management must become simpler and cover as many applications as possible. Diverse features are provided to solve minor issues right up to complex tasks.

Tense-Data integration software

Dynamic connectors

Dynamic connectors allow the connection of endless software systems without manual effort. The structures of the source and the target systems are automatically retrieved and graphically represented for the mapping process. Reduce the effort to connect systems and avoid mistakes by manual system descriptions.

Referential integrity

Existing dependencies (primary keys, foreign keys) between the data are integrated into the target system. Tensei-Data does not simply copy the existing dependencies into the target system - it constructs the correct referential dependence depending on the already existing information of the target system. That preserves the correctness of the referential integrity when depending keys are changing. (Read a Use Case)

Normalization

Normalization allows the extraction of data from the source system and avoids redundancies in the target system. Such a process is normally complex and requires an additional effort. Tensei-Data extracts the data depending on the specifications and provides the created dependencies for the linking of the dependent data. (Read a Use Case)

Virtual Views

Tensei-Data allows the creation of virtual views on the existing data which create new relations and aggregations. This technique provides the possibility to simplify the data exchange and to reduce complex integration steps into simplified approaches. (Read a Use Case)

Transformers

A row of basic transformers are already included in the Tensei-Data system to modify the data in diverse ways. Multiple transformers can be connected in series to execute various modifications on the data. This flexibility enables endless ways to transform data regarding diverse use cases. (Read a Use Case)

Automatic execution

The execution of the integration and transformation processes can be established continuously or manually. For the continuous execution are Cronjobs (time-based execution) or Trigger (event-based execution) available. These can be set within the system and are executed automatically. (Read a Use Case)

Furthermore, the Triggers allow the execution of processes depending on external events (storage of a file on a FTP server, request of a URL, etc.) or the successful execution of another process (Create process chains depending on the complexity of connected processes).

Scalable

The system is based on a modern software stack of Scala and Akka. The advantages of this agent based system are scalability by the Akka cluster and parallelization that can be upscaled depending on the number of available agents.

Diverse database systems and file types

Tensei-Data supports various databases and provides connection out of the box.

Databases Files File Access
DerbyTextLocal
H2CSVHttp
HyperSQLXMLFTP
FirebirdExcelFTPS
MariaDBJSONSFTP
Microsoft SQL ServerEmail 
MySQLTSV 
Oracle  
PostgreSQL  
SQLite  
others (via JDBC)  

Additional features

  • Automatic description of the data structure
  • Complex integration tasks can be subdivided into subtasks and automatically executed
  • Besides the graphical frontend exists an admin mode that allows the specification of database dependent queries
  • Filtering of data
  • Export / Import of existing cookbooks for reuse
  • Intuitive mapping visualization
  • Extreme short training periods
  • Demo system available