Knowledge Base Articles

Addressing Common Problems

• Blob Field is empty
• Could not find any files to read
• Function sequence error
• Things to avoid while designing data transformations
• Invalid Descriptor Index
• Best practice for calculations
• Switching from 32 bit to 64 bit version
• Understanding Scheduler
• Using Variables
• Unable to Open Registry Key
• Unable To Register
• Investigating Gpg4win Issues
• List of ODBC drivers download links

Repository

• Working with Repository
• Repository Tables
• Configuring SQL Server Repository
• Configuring Interbase/Firebird Repository
• Configuring MySQL Repository
• Configuring PostgreSQL Repository

Tips

• Choosing right ETL tool
• What is Complex Data
• Data Synchronization part 1
• Data Synchronization part 2
• Data Synchronization part 3
• Executing single copy of the package
• IMEX=1
• SSIS Excel Problem
• Getting latest version of SQL Server ODBC Drivers
• Email Notifications
• Inserting context of the file inside email message text
• Making ETL Transformations Read Only
• New Scheduler Options
• Stop executing ETL process
• Using Stored Procedures to load data
• Understanding Transformation Metadata
• Switching from Production to development environment
• Working with large lists of values
• Automating sending HTML emails
• Library of objects
• Processing EDIFACT Messages
• Automate File Processing
• Using web services a practical example
• Processing HL7 Messages
• Advantages and disadvantages of working with XML
• ETL and XSLT
• XML Transformation
• ETL Version Control why you need it
• We made it easy to get support for ETL Software
• How to split a file with Advanced ETL Processor
• Loading data files from different operating systems
• Working with very wide fixed width file
• Loading data from HTML tables
• Creating Reports
• Data Quality
• Performing Row Denormalisation using Case function
• Processing files based on modification date
• Calculating Group ID and Record ID
• Working With Python
• Extracting text from PDF file
• Extracting data from PDF tables
• Extracting Information from MSG Files
• SalesForce BULK API
• Update is slow

• Working with Greenplum
• Connecting to Google Spreadsheet
• Connecting to SalesForce
• Connecting to Slemma
• Connecting to Twitter
• Connecting to Google Drive
• Connecting to Dropbox
• Connecting to Amazon Drive
• Connecting to One Drive
• Connecting to HiDrive
• Connecting to Yandex Disk
• Connecting to Box
• Connecting to Amazon
• Connecting to Azure
• Connecting to Gmail
• Connecting to Microsoft Email Servers (office365.com,outlook.com and live.com)
• How to register your app for Office 365 with OAuth 2.0 authentication
• How to obtain RabbitMQ Exchange name and routing key