The Integration tool is an etl-tool for Dynamics CRM which allows you to insert
update records in Dynamics CRM. But not only this, you can use it to execute sql-commands against any databases and execute Commandline commands with it as well!
Learn how to use the tool with the
Integration Tool Tutorial
Contributors are welcome!
- Make sure .Net 4.5.2 is installed
- If you find any errors, please post them under issues.
- If you require any features, please post them under issues with the type feature.
- If you have problems using the tool, please post under discussion.
If you'd like to contribute, please
and/or create a fork directly on github.
Sourcecode moved to Github
Releases will be published here in future as well!
The tool is made up of modules (red in the graphic below), so that it will be easy to extend it with new functionality.
Currently the tool supports the following types of modules:
Each module is capsuled within an assembly, that implements the complete functionality of a module like the configuration-window and the execution-method. As entrypoint it must provide a class implementing the IModule-interface.
New in Version 1.7
New in Version 1.6
- CRM Target: Fixed bug in DateTime conversion - Thank you Lis for posting the issue!
New in Version 1.5
- Setup now creates Startmenu Integration Tool Designer
- Improved UI, especially the menu
- New Module "Execute CMD" (allows to execute any commandline command)
- New Module "ODBC Execute"
New in Version 1.4
- In case of error, an alternative path can be followed!
- New Module "Load from ODBC"
- New Module "MSSQL Execute" step
- New Module "Send Email"
- New Module "Write to eventlog" (needs elevated rights to write to the first time!)
New in Version 1.3
- Connections are now saved in separate file to enable staging
- Configurable if following items should be executed on error of previous item or not
- Properties appear when selecting item
- Stringtranformation-module can PadLeft and PadRight
- PrimaryKeys in CrmTarget can now be deleted again
- Improved testing a little
- Change to beta as I need more feedback!
New in Version 1.2
- Setup has now a UI
- Tested with CRM 2015
- SDK-Assemblies from CRM 2015. Older versions of CRM will still continue to work!
- Bugfix Excel-Source: Crashes no longer when invalid file chosen.
- Bugfix CRM-Target: When reopened, available primarykeys were not there.
- Bugfix CRM-Target: Fault was there when importmode create was selected.
- Bugfix: Cancels in step- and connectionconfigs work now correctly.
New in Version 1.1
- Module ColumnConcatenation
- Improved error handling
- Improved display of run status
- Improved icons
- Fixed bug in sql-source
- Module StringTransformation
- Module AddDefaultValue
- Module SqlSource
- New Feature DataFilter in Transformations
Contact me if you want to become a contributor!