Home
Reference
Find details on the SPL language, toolkits, APIs, commands, and more.
Toolkits
A toolkit is a set of SPL artifacts, which are organized into a package. Toolkits make SPL or native functions and primitive or composite operators reusable across different applications.
Toolkits
Toolkit com.teracloud.streams.teda 4.0.0
Developing applications
Configuring Solutions
Configuring ITE Applications
Data output
Generating output data for databases

Welcome
Learn about the core capabilities of Teracloud® Streams, its architecture, and key concepts.
Installing
Use this information to install, upgrade, and uninstall the Teracloud® Streams product.
Configuring
Create a basic or an enterprise domain which is a single point for configuring and managing common resources, security, and instances.
Administering
Administer the product by using the Teracloud® Streams graphical user interface, APIs, or the streamtool command-line interface.
Developing
Develop stream applications with the Streams Processing Language (SPL), Java, and Python.
Troubleshooting
Resolve problems with Teracloud® Streams using the troubleshooting tools provided with the product as well as the resources offered by Teracloud Support.
Reference
Find details on the SPL language, toolkits, APIs, commands, and more.
- APIs
  Application programming interfaces (APIs) provide functions that simplify applications development.
- Job configuration overlays
  You can specify or change configuration parameters when you use the submitjob or updateoperators operations. The settings control submission constraints, host constraints and locations, and operator status. Parameters are captured and updated in the configuration JSON file. When you change the values in the job configuration overlay file, the changes override any previously set values.
- Commands
  Teracloud® Streams provides a number of commands you use to perform tasks.
- Operator model
  An operator model is an XML document that describes the basic properties of a primitive operator.
- Streams Processing Language (SPL)
  Streams Processing Language (SPL) is a distributed data flow composition language that is used in Teracloud® Streams. SPL has primitive types, program structures, and definitions that are tailored for streaming data.
- Toolkits
  A toolkit is a set of SPL artifacts, which are organized into a package. Toolkits make SPL or native functions and primitive or composite operators reusable across different applications.
  - Specialized toolkit requirements and restrictions
    Several of the specialized toolkits require RPMs that are not required by the Teracloud® Streams product. There are also toolkit restrictions on some platforms.
  - Toolkits
- SPLDOC markup
  You can use SPLDOC markup in the descriptions associated with the SPL artifacts in a toolkit. The spl-make-doc command generates HTML documentation from the marked up artifacts.
Glossary
Use this glossary to find terms and definitions for Teracloud® Streams.

Generating output data for databases

The framework implements file to file processing. If you want to have CSV output files that contain data that can be used to add data to the tables in a database, you need the table-based output type in your application. As the records of one input file can end up in different tables, one input file produces many output files in this use case.

About this task

Configure the application to produce table-based output data files per each input file.

Procedure

In the file <PathToYourApplication>/config/config.cfg, find the ite.storage.type parameter description
To select the table-based output type for your application, set the parameter as follows: ite.storage.type=tableFile
In the file <PathToYourApplication>/config/config.cfg, find the ite.businessLogic.transformation.outputType parameter description
To select the table-based output type for your application, set the parameter as follows: ite.businessLogic.transformation.outputType=tableStream
In the file <PathToYourApplication>/config/config.cfg, find the ite.storage.tableNames parameter description
Assign the names of the tables that are used by your application to the parameter, for example: ite.storage.tableNames=VOICE_CDR,SMS_CDR

Then, another application uses the output files, for example to load the content of these CSV files into a database.

This output stream becomes the input of the TableRowGenerator. A tuple contains a single table row and one hash code for deduplication. If an input record results in multiple table rows or input to different tables, the Transformer must send the appropriate number of tuples.

The TableFileWriter uses the table names that you configure. For each table name, a dedicated spl.adapter::FileSink operator is used.