16 February 2017

SSIS & MS Dynamics CRM using Kingsway

Connecting to the CRM entities for loading or fetching data would be the tedious job if done from scratch, Kingsway ( Download from here ) came up with an intermediate connector to help or streamline the connectivity.
(1) Installed the Visual Studio (BITS) for BI development ( Download from here )
(2) Install the Kingsway SSIS Integration Toolkit for Microsoft Dynamics 365( Download from here )
(3) DataBase Driver which needs to be connected for data pull/push (SQL/ORACLE/MYSQL etc.)

Now we have the development environment set let connect to data sources:

For CRM connection:
(1) Right click on the connection manager
(2) Select new Connection
Select Type Dynamics CRM  (as Shown below)
Provide needed CRM URL and the Organization name 
Drop the Data Flow Task to perform needed BI operation
Within data Flow Task you will observe 3 new tool items added for dynamics CRM as shown below
Select desired based on the business needed, here I've selected as source which has the needed source type as an entity-entity name (source Entity)

For any further details please don't hesitate to drop an comment happy to respond 

08 February 2017

SSIS Script Task : ConnectionString for ADO.Net & OleDb ConnectionManager

In the switching world developer often needs to toggle between connection managers and wish the code operates as its expected.However, the execution engine is yet to be smart enough to undertake the difference.
Connection Manager TypeConnection Manager Name
ADOADO Connection Manager
MSOLAP90Analysis Services Connection Manager
EXCELExcel Connection Manager
FTPFTP Connection Manager
HTTPHTTP Connection Manager
ODBCODBC Connection Manager
OLEDBOLE DB Connection Manager

For those pin point here a code that worked for me and happy if works for you as well.
FOR ADO.NET Connection Manager

SqlConnection sConnection = new SqlConnection();
sConnection = (SqlConnection)(Dts.Connections["MyConnectionManagerADO.NETName"].AcquireConnection(Dts.Transaction) as SqlConnection);
var connection = sConnection.ConnectionString.ToString()

FOR OLEDB Connection Manager

var oConnection = Dts.Connections["MyConnectionManagerOLEDBName"].ConnectionString.ToString().Trim();
oConnection = oConnection.Replace("Provider=SQLNCLI10.1;", "").Replace("Provider=SQLNCLI11;", "").Replace("Provider=SQLNCLI11.1;", "").Replace("Auto Translate=False;", "");

Rate Now: