December 26, 2023
The world of data is vast and ever-expanding, fueled by the relentless growth of big data. This poses a significant challenge to traditional Extract, Transform, and […]
April 15, 2021
Infometry’s Google Sheets Connector is the only Informatica Certified native Cloud connector available for IICS platform. Infometry’s Connectors are supporting the latest version of Google Sheets APIs, enable seamless integration and real-time Data Analytics. Infometry’s Google Sheets Connector for Informatica enables easy application integration, data extraction for downstream applications, and ETL for Enterprise Data Warehouse supporting.
March 1, 2019
Problem Description-
Several times a user would want to upload and download files from the remote machine to a local machine using FTP/SFTP. As to transfer files from the Protocol system the user needs privileges along with a proper connector to transfer a file from the Informatica platform to another system or vice versa.
February 18, 2019
Problem Description
Customers/Users face issues in picking multiple CSV files with having the same base name from a directory and generates multiple Excel file for each CSV file. The Excel files need to be generated based upon either percentage of available filtered records or exact number of records and maximum records allowed in a single excel file. The filtration of records is based upon the specific column and its specific value.
February 18, 2019
Problem Description
Customers/Users face issues in splitting a CSV file into multiple CSV based upon some specific column and its specific value of that column.
Challenges to User/Developer
In IICS, above mentioned problem can be solved through Java Transformation.
The CSV file needs to be split into multiple CSV files.
Move the original CSV file to other location.
February 18, 2019
Problem Description
Customers/Users face issues with loading Excel files from SFTP remote server to local machine and convert the excel file to CSV file in mapping on IICS.
Challenges to User/Developer
In IICS, above-mentioned problem can be solved through Java Transformation.
The Excel file needs to be transferred to the local machine (where the secure agent is installed).
The locally available Excel file needs to be converted to CSV file.
Move the original Excel file which we got from SFTP remote server to other location.