Wednesday, June 10, 2009

Migrating: Goldmine -> MS CRM

What is a CRM application without data? In my experience datamigration/integration is one of the importants part of your project.

As you might know I am working at this moment on migrating data from Goldmine 5.5 (MS SQL implementation) to MS CRM 4.0. To get more information about Goldmine I used some information from Scribe templates, but also used this website a lot.

To make it more easy we also use an extra leading data source. We choose to add some columns in table of Goldmine. To retrieve you extra columns you have to update the Goldmine Adapter with MetadataConfig tool, which you could find in Scribe directory.

You have to add your columns in the Goldmineadapter.xml and upload them with the Metadataconfig tool. Please make backup of xml file first :-)

If you succeeded you will see the fields when connecting to Goldmine in the workbench. Some more tips/tricks in next post.

Scribe Integration: Error(s) trying to run DTS in Scribe Console (Enterprise Level)

I ran into some issues trying to schedule a DTS in the Scribe Console. The DTS was running fine in the Workbench. In our logs we did see several errors also:
- "Server execution failed (Error code=80080005)"
- "Error initializing the Message Processor"
- "Initialize failed (MsgProcDoc is null)"

We followed these steps (see topic 469) to solve the issue:

1) Check (correct) installation of MSMQ

2) Scribe Service Account should be/have :

a) a local admin on the Scribe server

b) a member of the Scribe Console Users Group

c) internet access.

The last (internet access) could be issue in Enterprise Environment. If its impossible to gain this privilige because security policies you could try this:

1) Logon to server with the account running the Scribe Services

2) Open IE and go to => Tools => Internet Options Click on the 'Advanced tab' scroll to 'Security'

3) Uncheck 'Check for publisher's certificate revocation'

4) Click 'Apply' and then 'OK'

You're DTS should now run succesfully.

The origin of this issue is not in the Scribe Software but an possible issue with the .NET framework. Please test it first in your development environment. The workaround is only needed when your account don't have internet access privilege.

Keep on integrating!

Thursday, June 4, 2009

The new Scribe website

After my long weekend, we had some holiday over here. I had nice surprise, which I guess many people were waiting for.

The website of Scribe(soft) had an extremely makeover! I must admit I like it and it is big improved considering the old website. The style was already displayed in new release of Scribe Insight 6.5 and its fresh and I actually could find my way around now :-)

So for many of us it's time, if you didn't already, to update the bookmarks:

- Openmind (forum & knowledge base)
- Downloads (of course the download page)

Go see it for yourself!

Enterprise Architecture - Platform Server

In an Enterprise Architecture we can setup Dynamics CRM in application and platform server. You could enhance performance by setting up a NLB for the application server, so you can use more than one application server. Of course this will also enhance your availibity of the application/

There was lot of discussion about what to do with platform server. Can we replicate it too, do we have to use cold fail over etc. The solutions is even nicer, a Microsoft Consultant pointed me to this whitepaper "Performance and Scalability Assessment of Customer Implementation"

The article describes a test where the platform server was deployed in NLB setup.

Check it out!