Transfer Data to the Synthesis Data Warehouse (SDW): Difference between revisions
Kate Racaza (talk | contribs) No edit summary |
Kate Racaza (talk | contribs) No edit summary |
||
| Line 11: | Line 11: | ||
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 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=== | ===Prerequisites=== | ||
1. | 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 with VB.NET, save this file to your C drive. | ||
Copy and paste the following data to the first sheet in the Excel workbook. | |||
{| {{table}} | {| {{table}} | ||
| Failure State||Time to F or S||Failure Mode | | Failure State||Time to F or S||Failure Mode | ||
| Line 67: | Line 67: | ||
Now that we're set up, select which language you | Now that we're set up, select which language you will be working with:''' | ||
[[APISDWTutorialVBA|Start the SDW tutorial for VBA >>]] | [[APISDWTutorialVBA|Start the SDW tutorial for VBA >>]] | ||
[[APISDWTutorialVBNET|Start the SDW tutorial for VB.NET >>]] | [[APISDWTutorialVBNET|Start the SDW tutorial for VB.NET >>]] | ||
Revision as of 15:40, 30 October 2015
 |
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.
Prerequisites
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 with VB.NET, save this file to your C drive.
Copy and paste the following data to the first sheet in the Excel workbook.
| 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 |
2. You'll need to reference the Microsoft Excel Object 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: