Informatica for Snowflake Data Cloud
Posted by: Snowflake net
The Snowflake connector makes it easy to connect your data pipeline to Snowflake's cloud data warehouse. Snowflake's unique architecture provides cloud elasticity, native support for diverse data, and compelling performance at a fraction of the cost while eliminating the complexity of conventional data warehouses.
Overview
The Informatica Cloud connector for Snowflake is a native, high-volume data connector enabling users to quickly and easily design big-data integration solutions from any cloud or on-premises sources to any number of snowflake databases and warehouses.It makes it simple for any developer or business user to amass all their data, enable rapid analytics, and quickly make data insights available to all of the users, consumers and systems that need them.
Features
Productivity:
- Supports INSERT, UPSERT, UPDATE and DELETE operations.
- Create target table at runtime taking away all the complexity of DDL statements so that you can focus on DI task at-hand
- Pre- and post-SQL to go beyond the realms of DI task itself.
Security:
- Supports JDBC SSL-encryption end to end.
- Stores key credentials in encrypted manner in Informatica Cloud repository.
- Role based access.
Robust solution:
- Efficiently & accurately process ANY volume of data, without degrade.
- Built-in error management capabilities such as Notifications & Alerts.
Performance and Scale:
- Optimized for bulk inserts. Follows Snowflake best-practices to read or write your data.
- Supports partitioning which enables you to spawn parallel data pipelines end-to-end.
- Optimized cached look-up enabling faster turn around when referring table.
Flexibility:
- Parameterize and Override almost all properties at runtime.
- Informatica Cloud Secure Agent can be on-prem or hosted on AWS.
Comments (7)
If you notice so many questions about setting up the right connection to snowflake in admin console of IICS
There is not detailed documentation, So many get no jdbc driver and http status 403 etc. Tried 'additional jdbc params' as well passing db and schema
Even after adding the IP address in allow list on snowflake security , the connection can't be established.
1. I took snowflake trial
2. I took IICS trial
3. Able to login to both properly and have all the account, warehouse, db, login info .
Runtime Environment:Informatica Cloud Hosted Agent.
4. But yet the cannot establish the snowflake data cloud connection in informatica admin console. http status 403
Informatica is a good platform for me.I want learn this technology .could you grant me access to snowflake connecter.
Informatica is a good platform for me.I want learn this technology .could you grant me access to snowflake connecter.
and now i am free pool any opportunity in your project please in form me. :)
Informatica is a good platform for me.I want learn this technology .could you grant me access to snowflake connecter.
and now i am free pool any opportunity in your project please in form me. :)
Informatica is a good platform for me.I want learn this technology .could you grant me access to snowflake connecter.
and now i am free pool any opportunity in your project please in form me. :)
Informatica is a good platform for me.I want learn this technology .could you grant me access to snowflake connecter.
and now i am free pool any opportunity in your project please in form me. :)