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
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
Highlighted

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
SQL Migration to Azure Cloud
Gohulan in Azure Migration on
0 Replies
Windows 10 VPN and SQL with Meraki VPN
redtechguy in Windows 10 on
4 Replies
Windows 10 VPN and SQL with Meraki VPN
redtechguy in SQL Server on
1 Replies
HOW can i combine 3 columns as sub columns
Varghese97 in SharePoint Developer on
0 Replies
Excel with Sql Server connection
petyac81 in Office 365 on
0 Replies