Today I heard an interesting answer to the question : what is the difference between ETL and ELT ?
The answer is : in ETL the transformations are processed by the ETL tools while in ELT the transformations are processed by the target datasources (RDBMS). I guess that the rising scalability of databases allows this kind of data integration to be possible.
Lately, I have had problems connecting to the internet. The connection would last for 2, 3 or 5 hours before it would fail again.
After trying many methods, I found out that the problem was the TCP/IP protocol itself.
There is a way to repair a damaged TCP/IP protocol, which is a core component of Windows.
Under DOS, with administrator rights, type in the following commands :
This week, I attended a meeting about NoSQL. And so here is a summary of the notes i have taken and what i have learnt and understood, so far.
First, what is NoSQL ?
That term stands for (N)ot (O)nly SQL. A detailed definition can be found on Wikipedia.
CRM Dynamics contains native entities (contact, account, opportunity, appointment …).
The CRM SDK API already contains specific classes for these native entities.
It is possible to create customized entities. To use them in programs, i found that there
are two options for that : either use crm webservice or use the CRM SDK API. With the latter option, you have to use Dynamic entity to access your custom entities.
Here are the steps to run a plug-in in debug mode
1) In Visual Studio (BIDS), build the project
2) Copy the generated DLL file and the PDB file (they are located in the project folder, under bin\Debug) to the CRM assembly folder : C:\Program Files\Microsoft Dynamics CRM\Server\bin\assembly
3) Deploy or redeploy the plug-in using the Plug-in registration tool