Transfer Data to the Synthesis Data Warehouse (SDW)
 |
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: