问题描述
我正在一个项目中工作,其中现有应用程序在SharePoint 2010中运行,而数据库服务器是SQL Server 2008 R2。客户端在此服务器的外部数据库中有多个表,视图,存储过程,函数和作业,除了
SharePoint的内容数据库。
有一个与Oracle ERP的外部集成,即SQL Server外部数据库中的HRMS。在现有应用程序中,HRMS团队使用链接服务器提供SQL Server视图,然后使用代码访问HRMS数据。 (与Active Directory一起,HRMS也是
用于获取SharePoint 2010中的用户详细信息,即用户属性)
要求 - 我需要在SharePoint Online(Office 365)中实现此方案。客户计划将现有的SP 2010应用程序迁移到SPO。请建议如何通过代码或
以任何其他方式访问SharePoint Online应用程序中的此HRMS数据。
我是否需要将Azure用于此目的。请建议。
任何帮助都会非常明显!
Hi,
I am working in a project wherein existing application is running in SharePoint 2010 and DB server is SQL Server 2008 R2. Client has multiple tables, views, stored procedures, functions and jobs in an external database in this server apart from Content DB of SharePoint.
There is an external integration with Oracle ERP i.e. HRMS in SQL Server external DB. In existing application, HRMS team is giving a view to SQL Server using a link server and then HRMS data is accessed using code. (Along with Active Directory, HRMS is also used to get user details in SharePoint 2010 i.e user properties)
Requirement - I need to implement this scenario in SharePoint Online (Office 365). Client is planning to move existing SP 2010 application to SPO. Please suggest how can I access this HRMS data in SharePoint Online application via code or by any other means.
Do I need to use Azure for this purpose. Please suggest.
Any help would be highly appreciable !
这篇关于SharePoint Online中的HRMS Integartion(Oracle ERP)的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!