製品をチェック

CData Connect Cloud の詳細はこちら

  30日間無償トライアルへ

Use the OData Connector for FinancialEdgeNXT to Access Blackbaud FE NXT データ in Microsoft PowerPivot

Use the CData OData Connector for FinancialEdgeNXT to connect to live Blackbaud FE NXT データ in the PowerPivot business intelligence tool.

加藤龍彦
デジタルマーケティング

最終更新日:2022-09-21

こんにちは!ウェブ担当の加藤です。マーケ関連のデータ分析や整備もやっています。

This article will explain how to use the OData Connector for FinancialEdgeNXT to provide Blackbaud FE NXT データ as OData services and then consume the data in Microsoft Excel's PowerPivot business intelligence tool. Follow the steps below to retrieve Blackbaud FE NXT データ in Power Pivot.

  1. If you have not already connected successfully in the OData Connector for FinancialEdgeNXT administration console, see the "Getting Started" chapter in the help documentation for a guide.
  2. In Excel, click the PowerPivot Window icon in the PowerPivot tab to open PowerPivot.
  3. Click "From Other Data Sources". In the Table Import Wizard that is displayed, select the "Other Feeds" option in the "Data Feeds" section of the list.
  4. Enter the OData URL of the CData OData Connector for FinancialEdgeNXT, http://localhost:8032/api.rsc.

    You will also need to add authentication options in this step. Click Advanced and set the Integrated Security option to Basic. You will need to enter the User Id and Password of a user who has access to the CData OData Connector for FinancialEdgeNXT.

    The URL of the OData endpoint for the OData Connector for Blackbaud FE NXT. (Salesforce is shown.)
  5. Select which tables you want to import and click Finish.

    Tables selected in the Table Import Wizard. (Salesforce is shown.)
  6. You can now work with Blackbaud FE NXT データ in Power Pivot.

    The Pivot Table that is consuming OData feeds from the OData Connector for Blackbaud FE NXT. (Salesforce is shown.)

関連コンテンツ

トライアル・お問い合わせ

30日間無償トライアルで、CData のリアルタイムデータ連携をフルにお試しいただけます。記事や製品についてのご質問があればお気軽にお問い合わせください。