Transfer Data to the Synthesis Data Warehouse (SDW): Difference between revisions

From ReliaWiki
Jump to navigation Jump to search
No edit summary
No edit summary
Line 13: Line 13:
In the following tutorial, you'll learn how to use the Synthesis API to create a custom solution for moving data from an external data source over to the SDW of a Synthesis repository. To keep things simple, we'll use data from an Excel file to demonstrate this capability.  
In the following tutorial, you'll learn how to use the Synthesis API to create a custom solution for moving data from an external data source over to the SDW of a Synthesis repository. To keep things simple, we'll use data from an Excel file to demonstrate this capability.  


===Prerequisites===
===Create an Excel file for this tutorial===
1. Before you begin, create an Excel file named "SampleData." If you will be working in VBA, use this file to write your code; if working in VB.NET, save this file to your C drive.  
Before you begin, create an Excel file named "SampleData." If you will be working in VBA, use this file to write your code; if working in VB.NET, save this file to your C drive.  


Copy and paste the following data to the Excel file, be sure to select cell A1 in Sheet1 of the workbook when pasting the data.
Copy and paste the following data to the Excel file. Be sure to select cell A1 in Sheet1 of the workbook when pasting the data.
{| {{table}}
{| {{table}}
| Failure State||Time to F or S||Failure Mode
| Failure State||Time to F or S||Failure Mode
Line 59: Line 59:
|-  
|-  
|}
|}
2. You'll need to reference the Microsoft Excel Object Library. (For VBA, be sure to also [[Referencing_an_Object_Library|reference the SynthesisAPI.tlb library]].)
:For VBA, choose '''Tools > Reference''', and then select the library from the list. Click '''OK'''.
:For VB.NET, choose '''Project > Add Reference''', and then select the library from the COM tab. Click '''OK'''. On the code page, add an Imports statement for Microsoft.Office.Interop.Excel.


Now that we're set up, select which language you will be working with:'''
Now that we're set up, select which language you will be working with:'''

Revision as of 20:38, 17 November 2015

Template:InProgress

APIWiki.png


<< Back to Quick Start Guide

Synthesis Data Warehouse (SDW) Tutorial

The Synthesis Data Warehouse (SDW) — formerly called "Reliability Data Warehouse" — is a temporary data storage location in a Synthesis repository. It allows you to connect to external data sources and extract data for use in Weibull++, ALTA or RGA standard folios.


In the following tutorial, you'll learn how to use the Synthesis API to create a custom solution for moving data from an external data source over to the SDW of a Synthesis repository. To keep things simple, we'll use data from an Excel file to demonstrate this capability.

Create an Excel file for this tutorial

Before you begin, create an Excel file named "SampleData." If you will be working in VBA, use this file to write your code; if working in VB.NET, save this file to your C drive.

Copy and paste the following data to the Excel file. Be sure to select cell A1 in Sheet1 of the workbook when pasting the data.

Failure State Time to F or S Failure Mode
F 7380 Cracked
F 4956 Cracked
F 5451 Cracked
F 6779 Failed
F 7713 Aging
F 1807 Bending
F 5940 Chafing
F 2071 Arcing
F 8178 Loose
F 3006 Burned
F 1385 Broken
F 2432 No Contact
F 1169 No Contact
F 592 Shorted
F 24 Burned
F 453 Burned
F 382 Burned
F 774 Burned
F 53 Burned

Now that we're set up, select which language you will be working with:

Start the SDW tutorial for VBA >>

Start the SDW tutorial for VB.NET >>