Transact SQL – DateAdd and avoid overflow errors

Background Transact SQL has adequate support for Date arithmetic exposed through dateadd, datediff, etc. Interesting yesterday I ran into a stumbling block due to a relatively high value for the interval argument. It graciously handles ints intervals. But, choked on a bigint. Error Error Text Msg 8115, Level 16, State 2, Line 14 Arithmetic overflow … Continue reading Transact SQL – DateAdd and avoid overflow errors

Informatica – PowerCenter Express – Datatype – XML

Background As I dig more into Informatica and MySQL, found out that we were not properly copying XML column from SQL Server into MySQL.   Table Structure Here is our table structure. MSSQL MySQL   Informatica Original Table Structure Physical Data Object - Admin.CourseManagerUserLog Explanation: Later on, was cognizant that our XML Column, details, precision … Continue reading Informatica – PowerCenter Express – Datatype – XML

Informatica – PowerCenter Express – Data Sync – MSSQL to MySQL ( Using MySQL ODBC Driver )

Background In our last post we spoke about copying data from MSSQL to MySQL via using MySQL JDBC Driver. In this post, we will cover using an ODBC Driver.   Lab ODBC Drivers Availability MySQL's ODBC Driver is available here. As of June 28th, 2016, the current MySQL ODBC Driver is 5.3.6. Our targeted machine's … Continue reading Informatica – PowerCenter Express – Data Sync – MSSQL to MySQL ( Using MySQL ODBC Driver )

Informatica – PowerCenter Express – Data Sync – MSSQL to MySQL ( Using MySQL JDBC Driver )

Background A dated follow-up to our post on using Informatica - PowerCenter Express. In that post we copied data between two MS SQL Server Instances. In this post we will copy data from SQL Server to MySQL.   Outline Here is a brief outline of the steps we will take: Select a Driver to use … Continue reading Informatica – PowerCenter Express – Data Sync – MSSQL to MySQL ( Using MySQL JDBC Driver )

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