Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Establishing connection between Informatica Power Center and Smartsheet
Establishing connection between Informatica Power Center and Smartsheet
Comments
-
Hello!
We don't have integration between Informica Power Center and Smartsheet, but I'll add your vote for this to our enhancement request list for further consideration by our Product team.
Smartsheet offers sheet exporting and importing options:
Export sheets and reports: https://help.smartsheet.com/articles/770623-exporting-sheets-reports-from-smartsheet
Import as new sheet: https://help.smartsheet.com/articles/504553-importing-files-to-create-new-sheets
If you have development resources at your organization, you might also check out our API: https://smartsheet-platform.github.io/api-docs/
-
Informatica Power Center is one of the Enterprise Data Integration tool by Informatica corporation. It follows same process of ETL (Extract, Transfer Load ) but has in-build concepts of data validation, data cleaning while extracting the data, transferring data by modifying as per the business query and while loading they are assigned with dimensional keys to load on data warehouse or operational data store (ODS).
It’s unique components serves it’s best features. Some of the components are:
1. Informatica domain serves as the primary unit for all the management and administration needs.
2. PowerCenter repository which resides in a relational database. They are the tables that contain the instructions to extract, transform, and load data.
3. Informatica Administrator is a web application that is used to administer the domain and information security.
4. Domain configuration stores the configured information for the domain.
5. PowerCenter Repository Service through which you can retrieve, insert and update metadata into database tables.
6. PowerCenter Integration Service makes you to read and manage integration workflows so that you can create more than one integration as per the business need.
7. Extracts data from sources and loads data to targets.
8. Web Services Hub is a gateway that exposes all the primary functionality of the product to external clients through web services.
9. SAP BW Service helps in extracting the data from different sources and loads it to SAP NetWeaver BI.
10. PowerCenter Client consists of the tools to manage the repository- the receiver. It helps in designing the mappings, the mapplets, and the sessions to load the data.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives