How-to

How to add a timestamp column from regex on filename during file ingestion?
Datafoundry fixed-width ingestion provides an option to append new columns which are extracted from a "match regex" and "extract regex" ...
Mon, 24 Aug, 2020 at 9:14 AM
How to extract filename or part of file name using Data Transformation?
As an example below are the instructions to ingest a file with file name appended with a timestamp and use the Datafoundry pipeline to create a table with a...
Mon, 24 Aug, 2020 at 9:15 AM
How to configure SSL for DataFoundry using a PFX format SSL certificate?
Problem Description:  Infoworks DataFoundry service requires SSL certificate and private key as separate files to configure SSL encryption Many SSL ven...
Thu, 9 Jul, 2020 at 2:10 PM
How to configure a SQL server source with Windows AD based authentication
Problem Description The old SQL JDBC drivers were not supporting windows based authentication. In order to use AD windows authentication in Infoworks SQ...
Mon, 1 Jun, 2020 at 1:18 AM
Steps to perform Python Custom Transformation in Infoworks
Scenario: If a dataset like the one mentioned below: id,fname,lname,salary 1,Nitin,BS,10 2,Alex,P,20 3,Hrithik,R,25 And, the requirement is like he...
Wed, 18 Mar, 2020 at 12:29 AM
How to set up SSL for Infoworks RestAPI
Problem Description: How to set up SSL for Infoworks RestAPI. Affected Infoworks version: IWX-2.9.x Solution/Workaround: 1)Configure rest_api.con...
Fri, 21 Feb, 2020 at 2:50 AM
HOW TO: Create a Signed SSL certificate to enable SSL in Infoworks
This Solution article lists the steps to create a signed certificate using the CSR. 1. Create your private key and the Certificate Signing Request. ...
Thu, 13 Feb, 2020 at 8:58 AM
How to overcome wget --no-check-certificate issue while upgrading Infoworks
Problem description: How to overcome wget --no-check-certificate issue while upgrading Infoworks. Solution: The issue was with the wget that we do in b...
Thu, 7 Nov, 2019 at 1:57 AM
How to: Analyze the Teradata TPT logs
Problem Description: During the Teradata TPT ingestion, Infoworks DataFoundry would use the Teradata Parallel Transport Utility installed on the Infowor...
Mon, 21 Sep, 2020 at 2:01 AM
How to disable the row count query execution on the pipeline target table
Problem Description: During the pipeline build process we will run the row count query on the pipeline target table to show the record count in the job ...
Fri, 6 Sep, 2019 at 2:21 AM