Table of Contents
概述
拓扑和安全性
通过外部列表在 PerformancePoint 仪表板中包括 Oracle 数据(分步)
Home Database Mysql Tutorial 使用 Business Connectivity Services 将 PerformancePoint Serv

使用 Business Connectivity Services 将 PerformancePoint Serv

Jun 07, 2016 pm 03:08 PM
business use

本文提供有关如何使用 Microsoft Business Connectivity Services 将 Microsoft SharePoint Server 2010 中的 PerformancePoint Services 连接到 Oracle 数据源的链接。本文假定您已为使用 Microsoft SharePoint Server 2010 的服务器场上的 PerformancePoin

本文提供有关如何使用 Microsoft Business Connectivity Services 将 Microsoft SharePoint Server 2010 中的 PerformancePoint Services 连接到 Oracle 数据源的链接。本文假定您已为使用 Microsoft SharePoint Server 2010 的服务器场上的 PerformancePoint Services 和 Business Connectivity Services 配置了服务应用程序。下面是您在此方案中执行的操作摘要。

  1. 创建模型文件和外部内容类型来描述 SharePoint Server 如何连接到 Oracle 并检索库存数据。
  2. 将列表数据发布到 SharePoint Server。
  3. 配置安全性。
  4. 使用 PerformancePoint Services 创建网站、仪表板和 KPI。
  5. 为 PerformancePoint Services 创建 SharePoint 列表数据连接。

概述

在执行一些操作流程(例如采购、补给、分发或发货)时,您可能要包括 Oracle 数据以支持商业智能功能,例如报表、监视或分析。PerformancePoint Services 可以聚合来自不同源的内容以查看报表、记分卡或 KPI。Business Connectivity Services 直接地或通过 SOAP 或 Windows Communication Foundation (WCF) Web 服务连接到数据以在仪表板中包括外部数据,例如客户、产品、员工或销售。

例如,为家庭办公用品零售商工作的采购员可能必须每周决定一次要采购哪些物料、数量是多少以及将物料发送到哪些商店。在此示例中,可以在按商店和物料组织的列表中执行分析。从不同源收集数据。它包括列和突出显示过去物料销售情况的指示器。并且它具有指定主数据(例如商店编号、商店地址、物料描述或供应商地址)的列。一些列可从 SQL Server Analysis Services 多维数据集收集,而其他列来自存储有关零售商库存的信息的 LOB 数据库。采购员将在可编辑的列中提供要采购的数量。完成后,可将仪表板发布到 SharePoint 网站。将在那里继续执行采购流程,具体取决于数据驱动比较。

若要在 PerformancePoint Services 中使用 Oracle 数据作为数据源来完成此方案,您必须创建外部内容类型。外部内容类型类似于 SharePoint 内容类型,允许显示外部列表、Web 部件、Microsoft Outlook 2010、Microsoft SharePoint Workspace 2010 和 Microsoft Word 2010 客户端中的数据并与之交互。在外部内容类型中描述了外部系统后,可以在 PeformancePoint 仪表板中通过创建 SharePoint 列表数据连接将它用作数据源。Business Connectivity Services 可以连接到的外部系统示例包括 SQL Server 数据库、使用 Duet Enterprise for Microsoft SharePoint and SAP 的 SAP 应用程序、Siebel CRM 数据、Web 2.0 服务、自定义应用程序和基于 SharePoint Server 的网站。虽然此示例与如何连接到 Oracle 数据有关,但 Business Connectivity Services 运行时通过使用以下连接器支持连接到多种外部系统,如“拓扑和安全性”一节中的图表所示。

  • 预设的数据库、WCF 服务或 SOAP Web 服务连接器
  • 使用 .NET Framework 创建的连接器或定制的连接器
  • 第三方连接器,例如由 BizTalk Server 或由 Microsoft 合作伙伴的其他产品提供的连接器

在使用其他数据库(例如 Oracle、OLE DB 和 ODBC)时,无法使用 Microsoft SharePoint Designer 2010 创建外部内容类型。改用以下方法之一。

  • 创建一个 BDC 模型,并使用 Visual Studio 2010 或您喜欢的 XML 编辑器用 XML 描述外部内容类型。有关详细信息,请参阅创作 BDC 模型。
  • 创建 Web 服务或 .NET 连接程序集来为数据库中显示的外部数据提供接口。使用 SharePoint Designer 2010 为新服务建模。
  • 将 Oracle 架构表镜像到 SQL Server,然后使用 SharePoint Designer 2010 为 SQL Server 建模。

在此方案中,您将创建一个 Business Connectivity Services 模型并使用 Visual Studio 2010 中的 XML 编辑器,该编辑器提供 IntelliSense。

拓扑和安全性

下面是一个拓扑图,其中显示了必须为其配置安全性的不同区域。

使用 Business Connectivity Services 将 PerformancePoint Serv

  1. 您的 Oracle 连接可能需要连接字符串中的显式用户 ID 和密码参数。
  2. 在此示例中,身份验证模式指定用户的凭据映射到存储在 Secure Store Service 中的帐户。凭据传递给外部系统。身份验证模式为 Business Connectivity Services 提供有关如何处理传入身份验证的信息。
  3. PerformancePoint Services 和 Business Connectivity Services 的凭据集存储在专用的 Secure Store Service 数据库中。
  4. 需要运行 Secure Store Service 应用程序和代理才能存储 PerformancePoint Services 服务应用程序的无人参与服务帐户密码。无人参与服务帐户是用于访问 PerformancePoint Services 数据源的共享域帐户。PerformancePoint Services 使用 Secure Store Service 来存储无人参与服务帐户密码。在使用无人参与服务帐户之前,请确保 Secure Store Service 正在运行。有关详细信息,请参阅规划 PerformancePoint Services 安全性 (SharePoint Server 2010)。
  5. 在 PerformancePoint 仪表板设计器中定义数据源(例如 SharePoint 列表)并将其存储在 SharePoint Server 2010 上受信任的数据连接库中。通过 Microsoft SharePoint Server 2010 安全模型来保护存储在列表和文档库中的对象。在该模型之上,PerformancePoint Services 将产品功能添加到基本 SharePoint Server 2010 框架中,以确保数据源和仪表板内容的安全,并防止未经授权的访问。提供的四个服务器角色包括“管理员”、“高级读者”、“数据源管理者”和“创建者”。此外在仪表板设计器中,还在单个项目级别上设置了另外两个角色:“编辑者”和“读者”。
  6. PerformancePoint Services 使用 SharePoint Server 安全模型来控制用户对各种功能和任务的访问权限。

通过外部列表在 PerformancePoint 仪表板中包括 Oracle 数据(分步)

步骤
有关信息,请参阅

查看有关如何创建外部内容类型的信息。

如何:基于 SQL Server 表创建外部内容类型 (http://go.microsoft.com/fwlink/?linkid=202504&clcid=0x804)

按照“创作 BDC 模型”文档中的过程从头创建模型。

外部系统的 BDC 模型基本上是一个自动生成的 XML 文件。在使用 SharePoint Designer 2010 为 SQL Server 数据库、WCF 或 SOAP Web 服务或现有的 .NET 程序集连接器创建外部内容类型时,将生成该文件。连接到 Oracle 需要您自己创建 BDC 模型。

演练:创建您自己的 BDC 模型 (http://go.microsoft.com/fwlink/?linkid=202859&clcid=0x804) 及相关的视频:使用 Visual Studio 2010 创建用于 SharePoint 2010 的业务数据连接模型? (http://go.microsoft.com/fwlink/?linkid=202860&clcid=0x804)

修改用于连接到 Oracle 数据库的 BDC 模型。确保在 Secure Store Service 中使用 Oracle 凭据设置了应用程序定义。还请记住 Oracle 和 SQL Server 参数之间的语法区别。例如,在 Oracle 中,使用冒号 (:) 代替 @ 符号。

如何:使用 Business Connectivity Services 连接到 Oracle 数据库 (http://go.microsoft.com/fwlink/?linkid=202861&clcid=0x804)

为使 Business Connectivity Services 能够在运行时检索到正确的凭据以连接到 Oracle,应使用 Secure Store Service 将凭据存储在 SharePoint Server 2010 中。

有关 Business Connectivity Services 安全性的详细信息,请参阅 Business Connectivity Services 安全性操作 (SharePoint Server 2010)。

请参阅如何:使用 Secure Store Service 连接到外部系统 (http://go.microsoft.com/fwlink/?linkid=202862&clcid=0x804) 中的“用户登录帐户信息”一节。

在您和其他仪表板作者创建一个或多个要在仪表板中显示的视图后,即可创建包含这些仪表板项目的仪表板页面。设置仪表板页面后,即可向这些仪表板页面中添加项目,例如报表、记分卡和筛选器。

使用仪表板设计器创建仪表板页

有关详细信息,请参阅了解 PerformancePoint 报表类型 (http://go.microsoft.com/fwlink/?linkid=185512&clcid=0x804) 和了解 PerformancePoint 记分卡 (http://go.microsoft.com/fwlink/?linkid=185514&clcid=0x804)。

使用仪表板设计器创建报表和记分卡 (http://go.microsoft.com/fwlink/?linkid=202863&clcid=0x804)

创建仪表板项目(例如页面、报表视图和筛选器)之后,下一步是组合您的仪表板页面。

使用仪表板设计器为页面添加仪表板项目

您可以将 SharePoint 列表中提供的数据作为 KPI 的数据源包括在报表中,或作为网页报表包括在自定义报表中。在仪表板设计器中创建 SharePoint 列表数据连接报表类型。必须在 SharePoint 列表中对数据进行任何编辑。

使用 Business Connectivity Services 将 PerformancePoint Serv注意:

只有默认列表视图可用作数据源或者用作 KPI 或筛选器的事实或维度,在聚合中不会考虑该视图。例如,如果默认视图中隐藏了某列,则该列不出现在仪表板设计器的列表预览中。

创建 SharePoint 列表数据连接 (PerformancePoint Services)

其他安全步骤包括以下这些。

  • 必须在服务器场中将连接到 Oracle 数据的所有计算机上安装 Oracle 客户端。
  • 必须将透明网络基底 (TNS) 网络服务配置为从 SharePoint Server 连接到 Oracle。
    这对于服务器上的外部列表、Web 部件和配置文件页来说是必需的。当服务在应用程序服务器中运行时,最好在应用程序服务器上安装 Oracle 客户端。
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Hot AI Tools

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress AI Tool

Undress images for free

Clothoff.io

Clothoff.io

AI clothes remover

AI Hentai Generator

AI Hentai Generator

Generate AI Hentai for free.

Hot Article

Repo: How To Revive Teammates
1 months ago By 尊渡假赌尊渡假赌尊渡假赌
R.E.P.O. Energy Crystals Explained and What They Do (Yellow Crystal)
2 weeks ago By 尊渡假赌尊渡假赌尊渡假赌
Hello Kitty Island Adventure: How To Get Giant Seeds
1 months ago By 尊渡假赌尊渡假赌尊渡假赌

Hot Tools

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

How to use magnet links How to use magnet links Feb 18, 2024 am 10:02 AM

Magnet link is a link method for downloading resources, which is more convenient and efficient than traditional download methods. Magnet links allow you to download resources in a peer-to-peer manner without relying on an intermediary server. This article will introduce how to use magnet links and what to pay attention to. 1. What is a magnet link? A magnet link is a download method based on the P2P (Peer-to-Peer) protocol. Through magnet links, users can directly connect to the publisher of the resource to complete resource sharing and downloading. Compared with traditional downloading methods, magnetic

How to use mdf and mds files How to use mdf and mds files Feb 19, 2024 pm 05:36 PM

How to use mdf files and mds files With the continuous advancement of computer technology, we can store and share data in a variety of ways. In the field of digital media, we often encounter some special file formats. In this article, we will discuss a common file format - mdf and mds files, and introduce how to use them. First, we need to understand the meaning of mdf files and mds files. mdf is the extension of the CD/DVD image file, and the mds file is the metadata file of the mdf file.

What software is crystaldiskmark? -How to use crystaldiskmark? What software is crystaldiskmark? -How to use crystaldiskmark? Mar 18, 2024 pm 02:58 PM

CrystalDiskMark is a small HDD benchmark tool for hard drives that quickly measures sequential and random read/write speeds. Next, let the editor introduce CrystalDiskMark to you and how to use crystaldiskmark~ 1. Introduction to CrystalDiskMark CrystalDiskMark is a widely used disk performance testing tool used to evaluate the read and write speed and performance of mechanical hard drives and solid-state drives (SSD). Random I/O performance. It is a free Windows application and provides a user-friendly interface and various test modes to evaluate different aspects of hard drive performance and is widely used in hardware reviews

How to download foobar2000? -How to use foobar2000 How to download foobar2000? -How to use foobar2000 Mar 18, 2024 am 10:58 AM

foobar2000 is a software that can listen to music resources at any time. It brings you all kinds of music with lossless sound quality. The enhanced version of the music player allows you to get a more comprehensive and comfortable music experience. Its design concept is to play the advanced audio on the computer The device is transplanted to mobile phones to provide a more convenient and efficient music playback experience. The interface design is simple, clear and easy to use. It adopts a minimalist design style without too many decorations and cumbersome operations to get started quickly. It also supports a variety of skins and Theme, personalize settings according to your own preferences, and create an exclusive music player that supports the playback of multiple audio formats. It also supports the audio gain function to adjust the volume according to your own hearing conditions to avoid hearing damage caused by excessive volume. Next, let me help you

How to use Baidu Netdisk app How to use Baidu Netdisk app Mar 27, 2024 pm 06:46 PM

Cloud storage has become an indispensable part of our daily life and work nowadays. As one of the leading cloud storage services in China, Baidu Netdisk has won the favor of a large number of users with its powerful storage functions, efficient transmission speed and convenient operation experience. And whether you want to back up important files, share information, watch videos online, or listen to music, Baidu Cloud Disk can meet your needs. However, many users may not understand the specific use method of Baidu Netdisk app, so this tutorial will introduce in detail how to use Baidu Netdisk app. Users who are still confused can follow this article to learn more. ! How to use Baidu Cloud Network Disk: 1. Installation First, when downloading and installing Baidu Cloud software, please select the custom installation option.

How to use NetEase Mailbox Master How to use NetEase Mailbox Master Mar 27, 2024 pm 05:32 PM

NetEase Mailbox, as an email address widely used by Chinese netizens, has always won the trust of users with its stable and efficient services. NetEase Mailbox Master is an email software specially created for mobile phone users. It greatly simplifies the process of sending and receiving emails and makes our email processing more convenient. So how to use NetEase Mailbox Master, and what specific functions it has. Below, the editor of this site will give you a detailed introduction, hoping to help you! First, you can search and download the NetEase Mailbox Master app in the mobile app store. Search for "NetEase Mailbox Master" in App Store or Baidu Mobile Assistant, and then follow the prompts to install it. After the download and installation is completed, we open the NetEase email account and log in. The login interface is as shown below

How to use Xiaoai Speaker How to connect Xiaoai Speaker to mobile phone How to use Xiaoai Speaker How to connect Xiaoai Speaker to mobile phone Feb 22, 2024 pm 05:19 PM

After long pressing the play button of the speaker, connect to wifi in the software and you can use it. Tutorial Applicable Model: Xiaomi 12 System: EMUI11.0 Version: Xiaoai Classmate 2.4.21 Analysis 1 First find the play button of the speaker, and press and hold to enter the network distribution mode. 2 Log in to your Xiaomi account in the Xiaoai Speaker software on your phone and click to add a new Xiaoai Speaker. 3. After entering the name and password of the wifi, you can call Xiao Ai to use it. Supplement: What functions does Xiaoai Speaker have? 1 Xiaoai Speaker has system functions, social functions, entertainment functions, knowledge functions, life functions, smart home, and training plans. Summary/Notes: The Xiao Ai App must be installed on your mobile phone in advance for easy connection and use.

Simple guide to pip mirror source: easily master how to use it Simple guide to pip mirror source: easily master how to use it Jan 16, 2024 am 10:18 AM

Get started easily: How to use pip mirror source With the popularity of Python around the world, pip has become a standard tool for Python package management. However, a common problem that many developers face when using pip to install packages is slowness. This is because by default, pip downloads packages from Python official sources or other external sources, and these sources may be located on overseas servers, resulting in slow download speeds. In order to improve download speed, we can use pip mirror source. What is a pip mirror source? To put it simply, just

See all articles