I then set up my target, using the same SQL Server connection that I created in the previous post. I set the Source Object to Account and saw the simple preview of the accounts currently in. On the next wizard page, I reused the connection that I created in the second post of this blog series. On the first page of the wizard, I defined my ETL and set the operation for Insert. I first need to create the task BEFORE I can set up Outbound Messaging in. Next, I went to the Informatica Cloud task designer and created a new Data Synchronization task. This table holds some basic details for a given account. To start with, I decided to reuse the same CrmAccount table that I created for the last post. Outbound Messaging is such a cool feature of and a way to have a truly event-driven line of business application. In this solution, I (1) create the ETL task in the web-based designer, (2) setup Outbound Messaging to send out an event whenever a new Account is added, (3) receive that event on an endpoint hosted in the Informatica Cloud and push the message to the on-premises agent, and (4) update the local database with the new account. I originally tried to do this with a SQL Azure database, but the types of errors I was getting led me to believe that Informatica is not yet using a JDBC driver that supports Azure. Part 4 – Sending Data to Local Database.Part 3 – Sending Dynamics CRM Online Data to a Local Database.Part 2 – Sending Data to Dynamics CRM Online.Part 1 – Sending File Data to Dynamics CRM Online.In this post, I’ll show you how you can send real-time data changes from to a local SQL Server database.Īs a reminder, in this four-part blog series, I am walking through the following scenarios: This is the fourth and final post in a blog series that looked a few realistic usage scenarios for this platform. The Informatica Cloud is an integration-as-a-service platform for designing and executing Extract-Transform-Load (ETL) tasks.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |