Home

Connect database(SQL) to OCM

%3CLINGO-SUB%20id%3D%22lingo-sub-375672%22%20slang%3D%22en-US%22%3EConnect%20database(SQL)%20to%20OCM%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-375672%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EHello%2C%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3EIs%20there%20any%20chance%20to%20manage%20(ad%2C%20update%2C%20delete)%20all%20items%20(contacts%2C%20companies%2C%20deals%2C%20actions)%20by%20SQL%20or%20MSFlow%20(I%20saw%20only%20possibility%20to%20create%20new%20one%20by%20MS%20Flow).%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3EMany%20thanks%20%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-375672%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMS%20Flow%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOutlook%20Customer%20Manager%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESQL%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-376908%22%20slang%3D%22en-US%22%3ERe%3A%20Connect%20database(SQL)%20to%20OCM%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-376908%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F162647%22%20target%3D%22_blank%22%3E%40Iry%20Chen%3C%2FA%3E%20%2C%3C%2FP%3E%3CP%3E%3CFONT%3Emany%20thanks%20for%20recommendation.%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%3CFONT%3EDo%20you%20know%20where%20are%20shared%20contacts%2C%20companies%2C%20deals%20and%20actions%20stored%20for%20OCM%3F%20Maybe%20that%20it%20is%20all%20what%20I%20need%20to%20know.%20Thanks%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-376840%22%20slang%3D%22en-US%22%3ERe%3A%20Connect%20database(SQL)%20to%20OCM%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-376840%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20ZdenekWF%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIn%20Outlook%20Customer%20Manager%2C%20it's%20not%20feasible%20to%20connect%20to%20SQL.%20Regarding%20your%20request%2C%20it's%20recommended%20to%20post%20a%20thread%20in%20MSDN%20forum%20to%20check%20if%20there%20is%20a%20workaround%3A%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsocial.msdn.microsoft.com%2FForums%2Fen-US%2Fhome%3Fcategory%3Dsqlserver%26amp%3Bfilter%3Dalltypes%26amp%3Bsort%3Dlastpostdesc%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsocial.msdn.microsoft.com%2FForums%2Fen-US%2Fhome%3Fcategory%3Dsqlserver%26amp%3Bfilter%3Dalltypes%26amp%3Bsort%3Dlastpostdesc%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThanks%20for%20your%20understanding%2C%3C%2FP%3E%0A%3CP%3EIry%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
ZdenekWF
New Contributor

Hello,
Is there any chance to manage (ad, update, delete) all items (contacts, companies, deals, actions) by SQL or MSFlow (I saw only possibility to create new one by MS Flow).

Many thanks

2 Replies

Hi ZdenekWF,

 

In Outlook Customer Manager, it's not feasible to connect to SQL. Regarding your request, it's recommended to post a thread in MSDN forum to check if there is a workaround:

 

https://social.msdn.microsoft.com/Forums/en-US/home?category=sqlserver&filter=alltypes&sort=lastpost...

 

Thanks for your understanding,

Iry

Hi @Iry Chen ,

many thanks for recommendation.

Do you know where are shared contacts, companies, deals and actions stored for OCM? Maybe that it is all what I need to know. Thanks

Related Conversations
How to migrate BCM 2010 to OCM 2016
Deleted in Outlook Customer Manager on
2 Replies
Outlook Customer Manager
Erico Feitosa in Outlook Customer Manager on
4 Replies
A problem with the Zoom level of a Tab
Tavory in Discussions on
9 Replies
Counting Days
Tim Hunter in SQL Server on
2 Replies
SQL Server 2016 crashes
mrktos in SQL Server on
0 Replies