Suggest a new Article!

• About this documentation - Tag cloud
• Generalities
  • Java
    • Installing an embedded Java version in Stambia DI Designer
    • Choosing the right Java version
    • Configuring Java for Certificates and SSL
• Stambia DI Software
  • Semarchy Acquires Stambia - Product and Version Changes
  • Designer
    • Installation and Upgrade
      • Installing the Designer
      • Upgrading the Designer
      • Major version upgrade
        • Migration from S18 / S19 to S20
        • Migration from S17 to S18 / S19
      • Minor version upgrade
        • Upgrading guide for minor Designer versions
    • Release Notes
      • Designer S20.5.x
      • Designer S20.4.x
      • Designer S20.3.x
      • Designer S20.2.x
      • Designer S20.1.x
      • Designer S20.0.x
      • Designer S19.0.x
      • Designer S18.3.x
      • Designer S18.2.x
      • Designer S18.1.x
      • Designer S18.0.x
    • Configuration
      • Connecting to a secured Runtime
      • Configuring the JVM used by the Designer
      • Configuring JDBC drivers
      • Giving a Name to a workspace
      • Customizing the Project Explorer view
    • How To
      • Building Packages
      • Getting started with Designer Command Lines
      • Importing projects
      • Mapping - using Mapper utility
      • Mapping - upgrading Mappings
      • Impact Analysis - Analyzing how Stambia resources are linked together
      • Impact Analysis - displaying the required and missing dependencies for an item
      • Workspace - Restoring deleted objects
      • Workspace - reverting the Internal Resources (Technologies) to their defaults
    • Version Control Integration
      • About Version Control Integration
      • GIT
        • Installing Git plugins in Stambia Designer
      • SVN
        • Installing SVN plugins in Stambia Designer
        • Using SVN into Stambia Designer
  • Components
    • Components Download
    • Stambia DI S20 or higher
      • Components Download for DI S20 and higher
      • Getting Started with Components for DI 2020 (S20) and higher
      • Working with Sample Projects
      • How to uninstall a Component
    • Stambia DI S17, S18, S19
      • Components Download for DI S17, S18, S19
      • Getting Started with Components for DI S17, S18, S19
  • Runtime
    • Installation and Upgrade
      • Installing the Runtime
      • Installing the Runtime - as a Linux service
      • Installing the Runtime - in a CentOS 7 server
      • Installing the Runtime - on Docker
      • Upgrading a Runtime instance
      • Major version upgrade
        • Migration from Runtime S17 to S20
      • Minor version upgrade
        • Upgrading guide for minor Runtime version
    • Release Notes
      • Runtime S20.5.x
      • Runtime S20.4.x
      • Runtime S20.3.x
      • Runtime S20.2.x
      • Runtime S20.1.x
      • Runtime S20.0.x
      • Runtime S17.6.x
      • Runtime S17.5.x
      • Runtime S17.4.x
    • Configuration
      • Clustering
        • Runtime cluster: native load Balancing and Failover
        • Runtime cluster: webservice load balancing
        • Runtime cluster: Sharing delivery schedules between runtimes
      • Security
        • Changing the key used for password ciphering S20
        • Changing the key used for password ciphering - S17, S18, S19
        • Securing RMI, HTTP, and Web Services endpoints with TLS in Stambia DI 2020 and higher
        • Securing RMI, HTTP, and Web Services endpoints with TLS in Stambia DI Runtime S17
        • Securing the Runtime with User / Password, roles, and hostname / IP restriction
        • Defining keystores
      • Miscellaneous
        • Adding Java Options at the Runtime's startup
        • Automatically deleting the temporary files generated at Web Services invocation
        • Avoiding the Designer to rewrite runtime files at startup
        • Changing the Jython version used by the Runtime
        • Changing the memory capacity of the runtime
        • Changing runtime default ports
        • Changing the default temporary folder of the runtime
        • Controlling the log level of each session
        • Enabling connection pooling for JDBC Databases
        • Runtime Delivery Pulling S20 and higher
        • Runtime Delivery Pulling S17, S18, S19
        • Using environment variables and java properties in the configuration file
    • How To
      • Communicating with Runtime
      • Checking the Runtime's version number
      • Building deliveries from build scripts
      • Checking that the Runtime is up and running
      • Start delivery Tips
      • Session's auto-restart management
      • Backing up Runtime files and data
      • How to externalize the Runtime's properties directory
    • Log
      • How to configure the Runtime for recording RDBMS log in asynch mode
      • Runtime Session Logs
      • How to configure the Runtime for writing to a RDBMS log database
      • Purging sessions from the Runtime's log database
  • Production Analytics
    • Installation and Upgrade
      • Stambia analytics on Docker
      • Upgrading an Analytics installation
    • Release Notes
      • S 3.x
        • Analytics 3.9.x
        • Analytics 3.8.x
        • Analytics 3.7.x
        • Analytics 3.6.x
        • Analytics 3.5.x
        • Analytics 3.4.x
        • Analytics 3.3.x
        • Analytics 3.2.x
        • Analytics 3.1.x
      • S 2.x
        • Analytics 2.3.x
        • Analytics 2.2.x
        • Analytics 2.1.x
    • How To
      • Making Variables settable in Analytics
      • Manage your Delivery Projects through the Supervisor
      • Moving an Analytics installation to another Server
      • Making Process parameters settable in Analytics
      • Backing up Analytics data
    • Configuration
      • Changing Anayltics web session timeout
    • REST API
      • Getting started with Analytics HTTP REST API
  • License Server
    • Installation and Upgrade
      • Installing the License Server
    • How To
      • Define a static or a LDAP filtering and customize filtering
      • Define a custom certificate and customize SSL options
      • Operating the License Server
      • Watching the License Usage
    • Release Notes
      • Licenses Service 1.4.x
• Technology Articles
  • Cannot find a technology?
  • Actian Vectorwise
    • Stambia DI for Actian Vectorwise
    • Release Note
      • Stambia DI S20 or higher
        • Actian Vectorwise Component
  • Amazon Redshift
    • Stambia DI for Amazon Redshift
    • Loading data into Redshift via S3 buckets
    • Release Notes
      • Stambia DI S17, S18, S19
        • Amazon Templates
      • Stambia DI S20 or higher
        • Amazon Component
  • AMQP
    • Stambia DI for AMQP
    • Getting started with AMQP
  • Avro
    • Stambia DI for Avro
    • Getting started with AVRO Component
    • Release Notes
      • Stambia DI S20 or higher
        • Avro Component
  • Cassandra
    • Stambia DI for Cassandra
    • Release Note
      • Stambia DI S20 or higher
        • Cassandra Component
  • CMIS
    • Stambia DI for CMIS
    • Release Note
      • Stambia DI S20 or higher
        • CMIS Component
  • Command Line
    • Stambia DI for Command Line
  • DBase
    • Stambia DI for DBase
  • Elasticsearch
    • Stambia DI for Elasticsearch
    • Getting Started with Stambia's Elasticsearch connector
    • Connecting to searchguard secured Elasticsearch clusters
    • Working with joined documents
    • Release Notes
      • Stambia DI S20 or higher
        • ElasticSearch Component
      • Stambia DI S17, S18, S19
        • Elasticsearch Connector
        • Elasticsearch Templates
  • File
    • File Management
      • Stambia DI for File Management
      • Remove Header/Footer from files concatenated with Concat Files action
      • Deleting a directory with the FileDelete Action
    • Flat Files
      • Stambia DI for Flat Files
      • Sorting data when writing a flat File
      • Using File Property Fields
      • Reading Multiple files at the same time
      • Generating files with dynamic name
    • Multirecord Files
      • Getting started with hierarchical files
      • Loading data when source and target are hierarchical Files
      • Reading only a specifed range of records
      • Using Computed Fields
      • Ordering data when loading a hierarchical file
    • Transformation Scripting
      • Getting Started With Transformation Scripting
      • Removing an UTF BOM header
  • Firebird
  • FTP
    • Stambia DI for FTP
    • Sending FTP Commands to an FTP Server
    • Using a Certificate for a FTPS connection
    • How to retrieve multiple file with different mask in FTP
    • Checking FTP Get result in Execution Condition
    • Sending files with FTP or FTPS
  • Google Cloud Platform
    • Stambia DI for Google Cloud Platform
    • Getting started with Google Cloud Platform Stambia DI S20 or higher
    • Getting started with Google Cloud Platform with S17, S18 or S19
    • Release Notes
      • Stambia DI S20 or higher
        • Google Cloud Platform Component
        • Google BigQuery Component
      • Stambia DI S17, S18, S19
        • Google Platform Templates
        • Google Cloud Platform Addon
        • Google BigQuery Addon
        • Google BigQuery Templates
    • Google Cloud Storage
      • Stambia DI for Google Cloud Storage
      • Getting started
        • Stambia DI S17, S18, S19
          • Getting started with Google Cloud Storage S19
        • Stambia DI S20 or higher
          • Getting started with Google Cloud Storage S20
    • Google Big Query
      • Stambia DI for Google BigQuery
      • Getting started
        • Stambia DI S17, S18, S19
          • Getting started with Google BigQuery S19
        • Stambia DI S20 or higher
          • Getting started with Google BigQuery S20
  • Google Sheet
    • Stambia DI for Google Sheets
    • Generating JDBC URL with OAuth2 Token for Google Sheet Component
    • Release Notes
      • Stambia DI S20 or higher
        • Google Sheet Component
      • Stambia DI S17, S18, S19
        • Google Sheet Addon
    • Migration
      • Stambia DI S20 or higher
        • Migration from Google Sheet Component API V3 to V4 / Stambia DI 2020
      • Stambia DI S17, S18, S19
        • Migration from Google Sheet Component API V3 to V4 / Stambia DI S17, S18, S19
    • Getting started
      • Stambia DI S20 or higher
        • Getting started with Google Sheet Component - Stambia DI 2020
      • Stambia DI S17, S18, S19
        • Getting started with Google Sheet Component - Stambia DI S17, S18, S19
  • Greenplum
    • Stambia DI for Greenplum
    • Release Note
      • Stambia DI S20 or higher
        • Greenplum Component
  • H2
    • Stambia DI for H2
  • Hadoop
    • Stambia DI for Hadoop
    • Getting started with Hadoop Connector
    • Release Notes
      • Stambia DI S20 or higher
        • Hadoop Component
      • Stambia DI S17, S18, S19
        • Hadoop Templates
    • Hadoop Distributed File System (HDFS)
      • Stambia DI for HDFS
      • Getting started with HDFS
    • HBase
      • Stambia DI for HBase
      • Getting started with HBase
      • Loading data with HBase importTsv tool
    • Hive
      • Stambia DI for Hive
      • Getting started with Hive
    • Impala
      • Stambia DI for Impala
      • Getting started with Impala
    • Sqoop
      • Stambia DI for Sqoop
      • Getting started with Sqoop
  • HTTP REST
    • Retrieving and Mapping whole HTTP REST response into one target field
    • Stambia DI for HTTP REST
    • Getting started with HTTP REST Metadata Stambia DI S20 or higher
    • Release Notes
      • Stambia DI S20 or higher
        • HTTP REST Component
  • Hyper SQL (HSQL)
    • Stambia DI for Hyper SQL (HSQL)
  • HyperFileSQL (HFSQL)
    • Release Note
      • Stambia DI S20 or higher
        • Hyperfile Component
  • IBM DB2
    • Release Notes
      • Stambia DI S20 or higher
        • IBM DB2 Component
    • IBM DB2/400
      • Stambia DI for IBM DB2/400
      • Reversing CCSID in DB2/400 database
    • IBM DB2 UDB
      • Stambia DI for IBM DB2 UDB
  • IBM Informix
    • Stambia DI for IBM Informix
    • Release Notes
      • Stambia DI S17, S18, S19
        • Informix Templates
      • Stambia DI S20 or higher
        • Informix Component
  • IBM Lotus Notes
    • Stambia DI for IBM Lotus Notes
  • IBM Netezza
    • Stambia DI for IBM Netezza
    • Release Notes
      • Stambia DI S20 or higher
        • IBM Netezza Component
      • Stambia DI S17, S18, S19
        • IBM Netezza Templates
  • InterSystems Caché
    • Stambia DI for InterSystems Caché
    • Release Note
      • Stambia DI S20 or higher
        • Intersystem Caché Component
  • JMS
    • Stambia DI for JMS
    • Getting started with JMS in Stambia
  • JSON
    • Stambia DI for JSON
    • Using JSON Property Fields
    • Reading JSON nodes with varying names
    • Reading Multiple JSON files
    • Sorting data when writing a JSON File
  • Kafka
    • Stambia DI for Kafka
    • Getting started with Kafka
    • Release Notes
      • Stambia DI S20 or higher
        • Kafka Component
      • Stambia DI S17, S18, S19
  • Kerberos
    • Getting started with Kerberos
  • Ldap
    • Stambia DI for Ldap
    • Release Note
      • Stambia DI S20 or higher
  • Email
    • Stambia DI for Email
    • Sending an email with Stambia
    • Sending emails with Gmail SMTP servers
    • Sending the result of a SELECT query by email
    • Reading and sending Outlook 365 emails
  • MemSQL
    • Stambia DI for MemSQL
  • Microsoft Access
    • Stambia DI for Microsoft Access
  • Microsoft Azure
    • Stambia DI for Microsoft Azure
    • Release Notes
      • Stambia DI S20 or higher
        • Microsoft Azure Component
      • Stambia DI S17, S18, S19
        • Microsoft Azure Templates
    • Storage
      • Stambia DI for Microsoft Azure Storage
      • Getting started with Microsoft Azure Storage
    • SQL Database
      • Stambia DI for Microsoft Azure SQL Database
      • Getting started with Microsoft Azure SQL database
  • Microsoft Excel
    • Stambia DI for Excel
    • Getting started with Stambia's JDBC Excel Driver
    • Selecting an area with Excel Driver
    • Release Notes
      • Stambia DI S20 or higher
        • Microsoft Excel Component
  • Microsoft SQL Server
    • Stambia DI for Microsoft SQL Server
    • Using Bulk Load on a distant server with enableFileTransport option
    • Release Note
      • Stambia DI S20 or higher
        • Microsoft SQL Server Component
  • MonetDB
    • Stambia DI for MonetDB
  • MongoDB
    • Stambia DI for MongoDB
    • Getting Started with Stambia's MongoDB connector
    • Release Notes
      • Stambia DI S20 or higher
        • MongoDB Component
      • Stambia DI S17, S18, S19
        • MongoDB Addon
        • MongoDB Templates
  • MySQL
    • Stambia DI for MySQL
    • Release Note
      • Stambia DI S20 or higher
        • MySQL Component
  • Oracle
    • Stambia DI for Oracle
    • How to use Slowly Changing Dimension with Oracle
    • Preparing the Runtime environment for using Oracle Sql Loader
    • Release Notes
      • Stambia DI S20 or higher
        • Oracle Component
  • Oracle BI
    • Stambia DI for Oracle BI
  • Oracle RDB
    • Stambia DI for Oracle RDB
  • Paradox
    • Stambia DI for Paradox
  • Parquet
    • Getting Started with Parquet
    • Release Note
      • Stambia DI S20 or higher
        • Parquet Component
  • PostgreSQL
    • Stambia DI for PostgreSQL
    • Release Note
      • Stambia DI S20 or higher
        • PostgreSQL Component
  • Privacy Protect
    • Getting started with Privacy Protect
    • Stambia DI for Privacy Protect
    • Release Notes
      • Stambia DI S20 or higher
        • Privacy Protect Component
  • Progress Open Edge
    • Stambia DI for Progress Open Edge
    • Release Note
      • Stambia DI S20 or higher
        • Progress Component
  • RDBMS
    • Release Notes
      • Stambia DI S20 or higher
        • Base Component
        • Change Data Capture Component
      • Stambia DI S17, S18, S19
        • Change Data Capture Templates
        • Generic Templates
        • Specific Templates
        • Stored Procedure Templates
    • How To
      • Getting Started with Stored Procedures
      • Working with ODBC datasources - Stambia DI 2020 (S20) or higher
      • Executing SQL Queries at Connection initialization
      • Working with ODBC datasources - Stambia DI S17, S18, S19
  • SCP
    • Stambia DI for SCP
  • SSH
    • How to send files with the action "Send Files with SCP"
    • Stambia DI for SSH
    • How to use an SSH Server
  • Salesforce
    • Stambia DI for Salesforce
    • Release Notes
      • Stambia DI S20 or higher
        • Salesforce Component
      • Stambia DI S17, S18, S19
        • Salesforce Templates
        • Salesforce Connector 1.1.x
    • Demonstration Project
      • Salesforce Demonstration Project
      • Create a Salesforce Developer Account
      • Set Up the Demonstration Environnement
    • How To
      • How to attach files to Salesforce records
      • Configure the Metadata
      • Working with Salesforce Relations
  • Sampling
    • Getting started with Sampling
    • Stambia DI for Sampling
    • Release Notes
      • Stambia DI S20 or higher
        • Sampling Component
  • SAP
    • Stambia DI for SAP
    • Getting started with SAP
    • Release notes
      • Stambia DI S17, S18, S19
        • SAP Addon
        • SAP Templates
      • Stambia DI S20 or higher
        • SAP Component
  • SAP ASE (Sybase AS Enterprise)
    • Stambia DI for SAP ASE
    • Release Notes
      • Stambia DI S20 or higher
        • SAP ASE Component
      • Stambia DI S17, S18, S19
        • SAP ASE Templates
  • SAP Hana
    • Stambia DI for SAP Hana
    • Getting started with SAP Hana
    • Release Note
      • Stambia DI S20 or higher
        • SAP HANA Component
  • SAP IQ (Sybase IQ)
    • Stambia DI for SAP IQ (Sybase IQ)
    • Release Note
      • Stambia DI S20 or higher
        • Sybase IQ Component
  • Scripting
    • Stambia DI for Scripting
  • Snowflake
    • Stambia DI for Snowflake
    • Getting started with Snowflake
    • Release Notes
      • Stambia DI S20 or higher
        • Snowflake Component
      • Stambia DI S17, S18, S19
        • Snowflake Connector 1.0.x
        • Snowflake Templates
  • Spark
    • Stambia DI for Spark
    • Getting started with Spark
    • Release Notes
      • Stambia DI S20 or higher
        • Spark Component
      • Stambia DI S17, S18, S19
        • Spark Templates
  • Teradata
    • Stambia DI for Teradata
    • Release Notes
      • Stambia DI S17, S18, S19
        • Teradata Templates
      • Stambia DI S20 or higher
        • Teradata Component
  • Twitter
    • Getting started with Twitter
    • Stambia DI for Twitter
    • Working with Twitter API
    • Release Notes
      • Stambia DI S20 or higher
        • Twitter Component
  • Vertica
    • Stambia DI for Vertica
    • Getting started with Vertica database
    • Release Notes
      • Stambia DI S20 or higher
        • Vertica Component
      • Stambia DI S17, S18, S19
        • Vertica Templates
  • Web Services
    • Release Notes
      • Web Services Templates
    • Configuring the Metadata
      • Stambia DI S20 or higher
        • HTTP REST Web Services and WSDL Metadata / DI S20 and higher
      • Stambia DI S17, S18, S19
        • HTTP REST Web Services Reverse Wizard
    • Invoking
      • Stambia DI for Web Services Invocation
      • Getting started with invocation error handling
      • Tip for calling an HTTP REST service
      • Customizing the HTTP Verb at invocation
      • Retrieving the HTTP Headers returned by a Web Service
      • Retrieving the HTTP Response Code and Message returned by a Web Service
      • Investigating a REST webservice invocation issue
      • Sending raw, unstructured data, to a Web Service
      • Retrieving raw, unstructured data from a Web Service
      • Invoking a Stambia REST Web Service asynchronously
    • Publishing
      • Stambia DI for Web Services Publication
      • Getting started with Stambia Web Services Publication
      • Definition - Open API3
      • Definition - Swagger2
      • Customizing the Input / Output HTTP Memorization of messages of a Stambia Web Service
      • Customizing the HTTP Response code of a Stambia Web Service
      • Customizing the Input / Output HTTP Headers of a Stambia Web Service
      • Customizing the Input / Output HTTP Body of a Stambia Web Service
      • Customizing HTTP Path and Methods on which a delivery can be invoked
      • Retrieving and using URL Parameters in a Stambia Web Service
      • Choosing the Configuration at invocation
    • Security
      • Getting started with Proxy Security
      • Getting started with HTTP Security Metadata
  • XML
    • Stambia DI for XML
    • Using XML Property Fields
    • Reading XML nodes with dynamic names
    • Reading Multiple XML files
    • Validating an XML file with an XSD
    • Including empty or null values in XML files
    • Indenting an XML File using an XSL Transformation
    • Sorting data when writing an XML File
• Templates
  • Installation and Upgrade
    • Importing templates into a workspace
  • Templates
    • Replication
      • Getting started with Replicator Rdbms
      • Replicating a directory with Replicator Rdbms
      • Trim values in a Replicator Rdbms
• Development Hints and Tips
  • Using H2 Engine to test, invoke, ...
  • Managing passwords in Stambia DI
  • Actions
    • File
      • SCP
        • Getting multiple files with SCP
      • Delete Files
      • Wait for Files
        • Using File Wait to check files presence and act in consequence
      • Write a File
        • Writing at the top of a file
    • SQL
      • SQL Operation
        • Using transactions with SQL Operation
        • Sql Operation and SQL_ACTION_TYPE
    • Miscellaneous
      • Operating System Command
        • Getting the response of an Operating system command
  • Administration
    • Stambia CI/CD with Jenkins
    • Stambia CI/CD with Jenkins and Docker
    • Log
      • Adding log information to a process
    • How To
      • Creating a keystore and importing certificates
      • Changing the port of demo databases
  • Building Packages
    • Launch Package Configuration
  • Exists / Not Exists
    • Exists / Not Exist in Mappings
  • How To
    • Manage system versions and resolve resource conflicts using EMF compare tool
    • Reset tutorials demo databases
    • Using dataset operators in a mapping
    • Using Datastore Layers
    • Using parameters and variables set on a subProcess
    • How to use the mapping name in a mapping expression
    • Binding variables to a sub-process
    • Parameterizing JDBC connection properties
    • Re-creating a Table in a process
    • Calling a process in a loop, modifying the JDBC Url for each iteration
    • Force a process to end "WITH_ERRORS"
    • How to Pivot or Unpivot a table
    • Execution conditions on a bind link
    • Executing a process only when the input file exists
    • How to limit the number of parallel executions for a delivery
    • How to iterate a process on a list of files
  • Impact Analysis
    • Impact Analysis utility
  • Mapping Stages
    • Combining multiples sources with SQL set operators
    • Defining datatypes on stage fields
  • Metadata
    • Metadata XPath Expressions Wizard
    • Changing the name of temporary tables
    • Using metadata queries
    • Parameterizing metadata properties
    • Updating a table metadata
    • Using the Runtime Metadata
    • Using the Object Selection Metadata to make a customized Metadata view
  • Modules
    • Getting started with Modules
    • Modules and Scripting
  • User Defined Functions
    • Getting started with User Defined Functions
  • Variables and Parameters
    • Syntax
      • Overview of different syntaxes
    • How To
      • Storing variables in a database for global use in several processes
      • Re-using Variables and Parameters from a previous Action
      • How to use the Runtime date/time at execution
      • How to reference a schema in a Variable's Refresh Query
      • How to use a variable as a table physical name
      • How to use a process parameter in a mapping
• Support Procedures
  • Getting Support
  • Guidelines for submitting issues to the Support Team
  • Producing Java Thread Dumps and Java Heap Dumps
  • Technical tasks