How-to

How to read the ORC/Parquet files content in HDFS
Description: Some times we might need to read customers ORC/Parquet file content while debugging issues related to special characters/ encoding related ...
Tue, 28 May, 2019 at 12:51 AM
How to access the Big query audit logs
Description: Some times we need to access the Big Query audit logs to debug issues related to Big query export in Infoworks ADE. We can use bq command l...
Tue, 14 May, 2019 at 11:52 PM
How to track the Infoworks users who change the connection details for a source
Problem Description: Perform the below steps to track the Infoworks users who change the connection details for a source. a) Click on the settings tab ...
Thu, 9 May, 2019 at 2:35 AM
How to set the hive extra configurations variables for a Pipeline target export job to BigQuery
Problem Description: Sometimes we might need to set hive configuration variables during the Pipeline export job to BigQuery for below reasons. a) Tune ...
Tue, 9 Apr, 2019 at 2:29 AM
How to configure Push Down Engine for Non Cube queries in Hive
Description How to configure the Push Down Engine for Non Cube Queries. Prerequisites in Hive Please ensure that the below settings enabled in hive...
Wed, 6 Feb, 2019 at 12:33 AM
Infoworks HA Installation - 2 node setup
HA Installation - 2 node setup Requirements : Pre-Ha-installation: We assume that user is performing the below set in infoworks version 2.5.X or...
Mon, 24 Jun, 2019 at 3:03 AM
Complete HA setup guide for Infoworks in 3 Nodes using HA, Active and passive Machines
Installing HA with 3 node setup for Infoworks Applicable on: Infoworks Version- 2.3.X, 2.4.X, 2.5.X, 2.6.X Requirements : 3 Edge Node:[ 1 Active...
Mon, 24 Jun, 2019 at 3:03 AM
Import Pipeline configurations via REST-API
PROBLEM DESCRIPTION How to enable advanced configs of pipeline settings to be present when we import the pipeline JSON via REST-API? WORKAROUN...
Wed, 6 Feb, 2019 at 12:34 AM
How to Update JSQL Parser jar in Infoworks to handle Special Characters during Ingestion
PROBLEM DESCRIPTION: Some of the Oracle-Logs based Ingestion job will fail with the below error message: Exception in thread "main" net...
Sun, 13 Jan, 2019 at 11:27 PM
How to: Access Infoworks Cubes from Microstrategy
Description This article explains how to enable access to Infoworks Cubes from MicroStatergy Download Infoworks Cube JDBC driver,           wget...
Wed, 6 Feb, 2019 at 12:34 AM