IICS Connectors-File Types.xlsx

	A	B	C	D	E	F	G	H	I
1	Connectors	csv	xlsx	txt	Tasks	File Location	Any Other Restrictions?	References
2	Box - Read	Yes	No	?	Mapping, Data Transfer, DSS		Not suitable for restricted data (see Box terms of use : https://kb.wisc.edu/page.php?id=33978 )	https://integratedata.wisc.edu/data-tools/informatica/informatica-best-practices/	https://docs.informatica.com/integration-cloud/data-integration-free-and-paygo/current-version/box-connector/introduction-to-box-connector/box-connector-task-and-object-types.html
3	Box - Write	Yes	No	?	Mapping, Data Transfer, DSS		Not suitable for restricted data (see Box terms of use : https://kb.wisc.edu/page.php?id=33978 )	https://integratedata.wisc.edu/data-tools/informatica/informatica-best-practices/
4	SP - Read	Yes	Yes	?	Mapping(xlsx?), Data Transfer(?), DSS	Files from SP can only be written to the Secure Agent
5	SP - Write	Yes	Yes	?	Mapping(xlxs?), Data Transfer(?), DSS	Only files from Secure Agent can be written to SP
6	Excel - Read	No	Yes	?	Mapping, Data Transfer(?), DSS(?)	In order to read Excel File, it must exist on Secure Agent	Can only read single header. To read Multi Header, one workaround is to use Intelligent Structure Model.
7	Excel - Write	No	No	?	N/A		Have a case open with Informatica
8	Flat File - Read	Yes	No	Yes	Mapping, Data Transfer, DSS	Reads file from Secure Agent accessible location (Git repo?)only
9	Flat File - Write	Yes	Yes	Yes	Mapping, Data Transfer, DSS	Writes file to Secure Agent accessible location (Git repo?) only
10	S3 V2 - Read	Yes	No	Yes	Mapping, Data Transfer(?), DSS (?)		Possible to read/write from xls file instead of xlsx (jmw)
11	S3 V2 - Write	Yes	No	Yes	Mapping, Data Transfer(?), DSS (?)		Possible to read/write from xls file instead of xlsx (jmw)
12	SFTP (File Processor) - Read (from sftp server)	Yes	?	Yes	Mapping , Data Transfer(?), DSS	Files from SFTP server can only be sent to Secure Agent		https://docs.informatica.com/integration-cloud/data-integration-connectors/current-version/file-processor-connector/introduction-to-file-processor-connector/file-processor-connector-implementation.html
13	SFTP (File Processor) - Write (write to sftp server)	Yes	?	Yes	Mapping , Data Transfer(?), DSS	Only files from Secure Agent can be sent to SFTP server		https://docs.informatica.com/integration-cloud/data-integration-connectors/current-version/file-processor-connector/introduction-to-file-processor-connector/file-processor-connector-implementation.html
14	Google Cloud Platform bucket	Yes	No	?
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100