Support

Search

Sort by

Module Type

Total

153 Modules

    ODIN Modules

  • Database, Import

    SQL Server

    This module is used to read data from a SQL Server® relational database. The data can be imported by using a query or procedure. Procedure or Query parameters can be defined in a setting or setting file. ODIN will then execute the procedure or query for each set of parameter input.

  • Database, Export

    SQL Server Out

    This module is used to write data to a SQL Server® relational database. The data can be exported by using an insert/update query or procedure.

  • Export, Text

    STD_OUT

    This module is used to write data to Standard Out. The module can be used to eyeball the data when building the ODIN process.

  • Database, Import

    Sybase

    This module is used to read data from a Sybase® relational database. The data can be imported by using a query or procedure. Procedure or Query parameters can be defined in a setting or setting file. ODIN will then execute the procedure or query for each set of parameter input.

  • Database, Export

    Sybase Out

    This module is used to write data to a Sybase® relational database. The data can be exported by using an insert/update query or procedure.

  • Import, Utility Modules

    System List

    Gets system lists such as Language, Fonts etc.

  • Arithmetic, Utility

    Table Arithmetic

    This module is used to perform arithmetic operations on single columns within a table. For example, sum values in a column, average values in a column, calculate the standard deviation of values in a column, calculate the standard deviation of values in a column or calculate correlation between values in two columns.

  • Transform, Utility

    Table Designer

    This modules allows you to build your own custom reports using Opturo’s Table Designer. Using the Table Designer UI you can position your data, design your report, and view your report while developing in real time.

  • Transform, Utility

    Table Subset

    This module is used to retrieve a subset of data by providing the start row and column and end row and column.

  • Export, Utility Modules

    Template

    This module allows you to create an arbitrary template file and populate variables in the file with variables defined in TableSets.

  • Import, Text

    Text

    This module is used to read data from text based files. It supports multiple file formats. The module can be used to read data from a single text file or from a series of text files that are date stamped (e.g data.20080101.txt, data20080102.txt, etc.). To read a series of text files that are date stamped, define the file directory, file prefix (e.g. data.), date range, frequency and format (e.g. yyyyMMdd)...

  • Export, Text

    Text Out

    This module is used to write data to text based files. It supports multiple file formats. The module can be used to write data to a single text file or to a series of text files that are date stamped (e.g. data.20080101.txt, data20080102.txt, etc.). To write a series of text files that are date stamped, define the file directory, file prefix (e.g. data.), file date format (e.g. yyyyMMdd) and file...

SQL Server

This module is used to read data from a SQL Server® relational database. The data can be imported by using a query or procedure. Procedure or Query parameters can be defined in a setting or setting file. ODIN will then execute the procedure or query for each set of parameter input.

Inputs

  • viaSetting.txt
  • querySample.sql
  • prodecureSample.sql
  • parameter.txt

    • Outputs

  • output.xls

    • SQL Server Out

    This module is used to write data to a SQL Server® relational database. The data can be exported by using an insert/update query or procedure.

    Inputs

  • data.xls

    • Outputs

  • viaSetting.txt
  • querySample.sql
  • prodecureSample.sql

    • STD_OUT

    This module is used to write data to Standard Out. The module can be used to eyeball the data when building the ODIN process.

    Inputs

  • data.xls

    • Outputs

  • output.log

    • Sybase

    This module is used to read data from a Sybase® relational database. The data can be imported by using a query or procedure. Procedure or Query parameters can be defined in a setting or setting file. ODIN will then execute the procedure or query for each set of parameter input.

    Inputs

  • dastrlSetting.txt
  • querySample.sql
  • prodecureSample.sql
  • parameter.txt

    • Outputs

  • output.xls

    • Sybase Out

    This module is used to write data to a Sybase® relational database. The data can be exported by using an insert/update query or procedure.

    Inputs

  • data.xls

    • Outputs

  • viaSetting.txt
  • querySample.sql
  • prodecureSample.sql

    • System List

    Gets system lists such as Language, Fonts etc.

    Table Arithmetic

    This module is used to perform arithmetic operations on single columns within a table. For example, sum values in a column, average values in a column, calculate the standard deviation of values in a column, calculate the standard deviation of values in a column or calculate correlation between values in two columns.

    Inputs

  • data.xls

    • Outputs

  • output.xls

    • Table Designer

    This modules allows you to build your own custom reports using Opturo’s Table Designer. Using the Table Designer UI you can position your data, design your report, and view your report while developing in real time.

    Table Subset

    This module is used to retrieve a subset of data by providing the start row and column and end row and column.

    Inputs

  • data.xls

    • Outputs

  • output.xls

    • Template

    This module allows you to create an arbitrary template file and populate variables in the file with variables defined in TableSets.

    Text

    This module is used to read data from text based files. It supports multiple file formats. The module can be used to read data from a single text file or from a series of text files that are date stamped (e.g data.20080101.txt, data20080102.txt, etc.). To read a series of text files that are date stamped, define the file directory, file prefix (e.g. data.), date range, frequency and format (e.g. yyyyMMdd) and file suffix (e.g. .txt).

    Example

    Take a text file and output it to Excel.

    Basic example of converting file types.

    Inputs

  • data.txt

    • Outputs

  • output.xls

    • Text Out

    This module is used to write data to text based files. It supports multiple file formats. The module can be used to write data to a single text file or to a series of text files that are date stamped (e.g. data.20080101.txt, data20080102.txt, etc.). To write a series of text files that are date stamped, define the file directory, file prefix (e.g. data.), file date format (e.g. yyyyMMdd) and file suffix (e.g. .txt).

    Inputs

  • data.xls

    • Outputs

  • output.txt