web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Is there any way to ge...
Microsoft Dynamics GP (Archived)

Is there any way to get eConnect stored procedures to my local database

(0) ShareShare
ReportReport
Posted on by skonakanchi 65

Hi,

I would like to have all eConnect related stored procedures in my mock database . So that i can test the eConnect API in my local . I am unable to get the script of these stored procedure because these are all encrypted . Is there any way to do it ?. Please suggest. It is urgent

Thanks

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    Hi,

    First take a backup of the DB in which eConnect works or eConnect SP's exists,

    then restore it to the test database so all the structures like Tables, Functions and Stored procedures exists even if those are encrypted. so that u will be able to test the eConnect API

    Please follow the steps to create the test database,

    support.microsoft.com/.../871973

    Hope this helps.

    Regards,

    Santosh G

  • skonakanchi Profile Picture
    skonakanchi 65 on at

    Thanks, But  i want only  encrypted Stored procedures (eConnect) to copy to my mock data . Could you please help on this ?

  • Suggested answer
    soma Profile Picture
    soma 24,410 on at

    Backup the eConnect Database and restore it into new Mock  database. Then continue your test on mock database.

    Better if you have sample company Fabrikam, use this company to test your eConnect API. or Create a sample company Fabrikam and continue your test at this company.

    Hope this helps!!!

  • skonakanchi Profile Picture
    skonakanchi 65 on at

    Thanks ,Manual restore will not work for me . Because  i want to add these eConnect related  stored procedure scripts  to my Database Project (Mock Database) in Post deployment script  . This will recreates the mock database  every time when i run the test scripts .

    Please help me out on this .

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

News and Announcements

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Dan Liebl Profile Picture

Dan Liebl 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans