Welcome Guest!
Log in
News
Latest News
Download
Data Integration
Stambia DI Designer
Stambia DI Runtime
Stambia DI Components
Stambia DI Production Analytics
Documentation
Data Integration
Getting started
Reference
Articles and Technologies
Knowledge Base
Support
Forum
Search ...
Home
Documentation
Selective Display improves mapping readability
Subcategories
Generalities
Stambia DI Software
Technology Articles
Templates
Development Hints and Tips
Support Procedures
Display #
5
10
15
20
25
30
50
100
All
Title
Modified Date
About this documentation - Tag cloud
30 November 2016
Articles
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
Email
Password
Remember Me
Forgot your password?
Forgot your username?
Create an account