MSSQL Stored Procedure

(0) Share

Report

Posted on by SteveWhyte

575

Can I create a stored procedure on MSSQL Server that will do jobs like daily automation of a bulk import process from an external application database into the CRM database?

What is the recommended approach?

*This post is locked for comments

All responses (2)

Answers (0)

Suggested answer

Nadeeja Bomiriya 6,804 on at

Like (0)

Report

RE: MSSQL Stored Procedure

Hi Steve,

+1 to Guido and Alagu's comments.

Directly accessing CRM database is not recommended or supported.

You must always use the Web Services (Organization Service, Web API).

Kingswaysoft SSIS provides connectors for Dynamics CRM, so that you don't have to code low level connectivity.

Then you can use standard SSIS features and Kingswaysoft components to create a SSIS package.

You can then create a SQL Agent job to run the SSIS package on a a set time.
Suggested answer

Alagunellaikumar 6,210 on at

Like (0)

Report

RE: MSSQL Stored Procedure

Hi

It is not recommended way. but you can either SSIS or using organization data service. The difficultly of direct SP CRM is not only linked with single table behind the screen it was linked with many table(owner=>team/user table, custom entity table).

So writing SP is not nice way.

SSIS use kingsway soft

www.youtube.com/watch