A lot of XML and XSLT what we're supposed to with that?
Today I will show how to load XML data into the database using Advanced ETL Processor. For those just starting using Advanced ETL Processor I recommend watching the following online tutorial.
Once you done so follow the steps below.
1. Create target table (for example items table)
2. Create new transformation
3. Open Data reader properties
4. Set source type to XML
5. Select source file
6. Check Transform XML
7. Open XML Editor
8. Paste items XSLT from previous article (first one)
9. Click transform XML (Just to make sure that it works)
10. Click OK
11. Select TABLE and Row tags
12. Click OK
13. Here is the data
14. And last step step is to map the data and load it into the database
No comments:
Post a Comment