Informatica – PowerCenter Express – Data Sync – Introduction

Forward In an online article, Robert Sheldon, reviews a couple of ETL tools. The article is titled "Moving beyond SSIS: 5 third-party SQL Server tools for ETL". And, it is available here. He compares a hand fold of ETL Tools; here is his list: Informatica - PowerCenter SAS - Enterprise Data Integration Server Business Objects … Continue reading Informatica – PowerCenter Express – Data Sync – Introduction

Informatica – PowerCenter Express – Error – SEVERE: com.informatica.sdk.dtm.ExecutionException: [LDTM_0072] RR_4036 Error connecting to database

Background Trying to play around with Informatica Power Center Express on a new box and ran into the error pasted below. What were we trying to do? Basically all we were trying to do is review data on a Data Source. To do so, one will create a project add a data source and access Run \ … Continue reading Informatica – PowerCenter Express – Error – SEVERE: com.informatica.sdk.dtm.ExecutionException: [LDTM_0072] RR_4036 Error connecting to database