Stack Overflow
Stack Overflow

Questions tagged [iics]

IICS = Informatica Intelligent Cloud Services. Tag usage guidance needs to be added.

Informatica Intelligent Cloud Services (IICS) is an integration platform as a service (iPaaS).

Information: Informatica Cloud Application Integration: A Capabilities Overview (PDF).

63 questions
0
votes
1 answer

Access a text file in GCS from Informatica IICS with a parameter source object

I am using IICS to run a taskflow containing two mapping tasks. The data source is set as a parameter and is assigned in an assignment inside the taskflow. In the assignment I set the source of both mapping tasks equal to an input parameter created…
Macrus
  • 69
  • 6
0
votes
0 answers

Is there any documentation or article on how IICS IPU is calculated for different services (CDI, CAI, MI etc)

I did some research online and couldn't find how exactly the IPU is calculated. The only information I got is the different scalars used for different services. Is there any specific formula where the server type (CPU, memory) is a function, for the…
DDJ
  • 5
  • 4
0
votes
0 answers

Failed to generate swagger file in IICS

I am trying to generate swagger file in Informatica cloud administrator. I am getting the below error: I am not sure what am I doing wrong. The endpoint details, headers, response etc everything is correct. I was able to generate a similar file…
Bratty Neal
  • 121
  • 1
  • 1
  • 7
0
votes
1 answer

How to create a connection with Azure SQL Server with Informatica cloud IICS?

I tried to create IICS connection with Azure SQL Server. But I get this error: The connection test failed because of the following error: Error establishing socket to host and port, Reason: Connection refused. Does anyone know to fix this issue?…
Adam
  • 129
  • 6
0
votes
0 answers

Read dynamic csv file from Amazon S3 bucket to use as source in Informatica Cloud

I want to read a csv file from Amazon S3 bucket to use as a source for a mapping in Informatica Cloud.The csv file name is not constant, it will change everyday. How can this be achieved?
user2280352
  • 145
  • 11
0
votes
0 answers

How to read JSON data from flat file in Informatica cloud platform?

I have a flat file(.txt) generated from a web service having the contents something as below: Field1 Field2 ""key1": [{"somekey":"somevalue"}], "key2": "somevalue2" testvalueforfield2  As you can see from above structure Field1 of my…
Bratty Neal
  • 121
  • 1
  • 1
  • 7
0
votes
1 answer

How to capture Table Name of failed or success Mapping Configuration task into Snowflake Table using IICS?

I am trying to log the errors that occurs during loading the data into Snowflake table, and my table name is log_table. In this table,I have column, IICS_status,IICS_ERRORS and Table_Name. I would like to capture the Snowflake table name where data…
biggboss2019
  • 220
  • 3
  • 8
  • 30
0
votes
0 answers

Unable to test or publish app connection for File type in Application Integration IICS

I am trying to test or publish the File type app connection in Application integration. It is giving error message as "Unknown server error" when click on Test.
Rakesh
  • 3
  • 7
0
votes
2 answers

IICS no viable alternative at input '\n/* partner: Informatica -v 2.0 *

SELECT concat('-', column_1) as column_1, column_2 as column_2, concat('-', column_3) as column_3, 'hard_code_string' as column_4, column_5 as column_5, column_6 as column_6, column_7, column_8 as column_8, …
Rachel
  • 89
  • 3
  • 8
0
votes
0 answers

How to Drop and create new table everytime using Mapping IICS

My requirement is to drop table every time and create new table with updated schema. I have tried with PreSql in Target its not working, getting error as Invalid object table. Also, have used SQL activity in Mapping before calling to target, to drop…
Rakesh
  • 3
  • 7
0
votes
1 answer

How to load source file without header in IICS

I want to load flat file which is ~ delimited but doesn't any header into Snowflake table using informatica cloud integration service. Just wanted to know how to add header to source file or any turn around in order to map fields in fields mapping…
Shubham Bhoyar
  • 21
  • 3
0
votes
0 answers

Jira Cloud integration with IICS using CAI

We are trying to integrate JIRA Cloud API with IICS. Not finding enough information on how to configure this. Can someone please guide how to configure this in informatica CAI? Thanks
user19184678
  • 39
  • 5
0
votes
1 answer

IICS How Do You Orchestrate Scheduled Task Flows?

I would like to run multiple scheduled Task Flows against the same data source but only run one at a time. Example: Schedule "Nightly" runs once a day (expected runtime 30 minutes), Schedule "Hourly" runs once an hour (expected runtime 10…
summer fondness
  • 101
  • 1
  • 5
0
votes
1 answer

How to get flat files with no file structure as source and insert same data into table as target in IICS

I wanted to get the flat files as source without any file structure specified using IICS(Informatica Intelligent cloud services). Flat files names can be anything, and structure also will change any. And also need to create table dynamically based…
Rakesh
  • 3
  • 7
0
votes
1 answer

IICS - populate TIMESTAMP_TZ column with generated value

I am trying to populate TIMESTAMP_TZ column in Snowflake using the Informatica IICS from the Taskflow. In the taskflow I am using function fn:current-dateTime() which I am trying then in the mapping to convert to TIMESTAMP_TZ using the to_date()…
rholdberh
  • 475
  • 1
  • 5
  • 19
1 2
3
4 5