Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / Target specific CRM se...
Microsoft Dynamics CRM (Archived)

Target specific CRM server

(0) ShareShare
ReportReport
Posted on by Ivaylo Moshekov

Hi everyone,

I am importing bulk data on a daily basis using SSIS and KingswaySoft Components into on-prem CRM 2016. The server configuration consists of 2 full CRM servers, 1 SSIS server and 1 SQL server. IFD has been configured.

I am wondering whether is possible to target specific server node in my SSIS project? If it is possible, I could use both servers to do the work in parallel rather than just one of them and that will cut the dataflow execution time in half.

Any ideas are highly appreciated.

*This post is locked for comments

  • Ivaylo Moshekov Profile Picture
    Ivaylo Moshekov on at
    RE: Target specific CRM server

    By using a http port, I can open a specific CRM server directly on browser. However, SSIS cannot resolve the metadata.

    I guess I am just going to stick to the supported ways and work on other way of optimizations

  • Verified answer
    prt33k Profile Picture
    prt33k 6,907 on at
    RE: Target specific CRM server

    Yes Ivaylo.. with single affinity the same server will be hit.

    What you can try is to modify the binding of CRM server and add new binding on http(80) port. Then access the url directly on browser and see if re-direct is happening or not. If not then you can add connection manager for individual server with http binding.

    Not sure however how much is that supported though..

    Thanks,

    Prateek

  • Ivaylo Moshekov Profile Picture
    Ivaylo Moshekov on at
    RE: Target specific CRM server

    Hi Prateek,

    the NLB has been configured using the same guide you mentioned earlier, so I believe it is a software one.

    If I understand you correctly, no matter whether I use BDD or parallel data flows, they will always hit the same CRM server due to single affinity setting.

    Is my understanding correct?

  • prt33k Profile Picture
    prt33k 6,907 on at
    RE: Target specific CRM server

    Hi Alex,

    Yes - single affinity will hit the same machine.

    I do want to know how is it configured though and whether it is a s/w NLB or hardware one.

    Thanks,

    Prateek

  • ashlega Profile Picture
    ashlega 34,475 on at
    RE: Target specific CRM server

    NLB behavior depends on the configuration.. according to this:

    technet.microsoft.com/.../hh699803.aspx

    It's supposed to be configured for single affinity which means the same client (SSIS in this case) will be hitting the same server all the time. At least that's how I'm reading it:)

  • Suggested answer
    prt33k Profile Picture
    prt33k 6,907 on at
    RE: Target specific CRM server

    Hi Ivaylo,

    If you are using the virtual IP in connection manager then the load will get distributed - that is why we use load balancer.

    You can check this by opening the IIS logs and see if the request is appearing on both server - do this by running package for some 5-10k record so that you can see both server getting request.

    What you may want to do is to optimize SSIS package - use mutilple DFT or use BDD - to increase the server utilization.

    Thanks,

    Prateek

  • Ivaylo Moshekov Profile Picture
    Ivaylo Moshekov on at
    RE: Target specific CRM server

    Hi Prateek,

    I have a NLB setup up and running. However what I am trying to achieve is to utilize all available resources (in my example the 2 full CRM Servers) in order to insert huge chunks of data into CRM as quickly as possible. Assuming I am not mistaken, if I use the NLB address, the CRM connection manager in my data flow will connect to one of the CRM servers and use that to perform the job. In that way one of the servers will stay idle and the other one will be hard working. Isn't that correct?

  • ashlega Profile Picture
    ashlega 34,475 on at
    RE: Target specific CRM server

    ah.. ok. Then I don't think it's going to work since that's what it's going to keep doing (redirecting to ADFS for authentication). Like said above, we did not have IFD:)

  • Suggested answer
    prt33k Profile Picture
    prt33k 6,907 on at
    RE: Target specific CRM server

    Hi Ivaylo,

    I believe you already have a NLB setup - if not then do that - and then just use the virtual domain name to hit the CRM.

    You can connect to individual machine also but then you wont be able to distribute the load correctly and might end up under utilizing one machine while overkilling other. So recommended way is to have NLB configured and use that to load data.

    The guide below will help you in setting it up:

    blogs.msdn.microsoft.com/.../network-load-balancing-microsoft-dynamics-crm-2013

    Thanks,

    Prateek

  • Ivaylo Moshekov Profile Picture
    Ivaylo Moshekov on at
    RE: Target specific CRM server

    Yes I tried - I get an authentication error.

    I noticed that upon accessing the https://server1/orgname URL, it redirects me to adfs which then sends me to internalcrm.domain.com/orgname

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans