soltech data integration dotnetnuke, resumate, apatar , sql
DESCRIPTION
Step by step guide on how to use Apatar open source ETL tool to integrate proprietary resume database to DNN via SQL Server. SolTech builds custom software using .Net tools and Java tools. Call Soltech 4046106000 or email [email protected]TRANSCRIPT
DNNResumateApatarSQL
Integration Showcase
Step by Step
Can one build a complete end to end data integration between a proprietary database and a CMS. Challenge … Extract data from Resumate recruiting database to display available employment positions on DNN based corporate website – no programming !
SolTech. Inc http://www.soltech.net (404) 601-6000
Extract Data
Apatar – Free open source ETL Tool. Extract data from resumateAccess database to populateSQL database.
SolTech. Inc http://www.soltech.net (404) 601-6000
Source Tables – Access Proprietary
SolTech. Inc http://www.soltech.net (404) 601-6000
Target Tables – SQL Server
SolTech. Inc http://www.soltech.net (404) 601-6000
SQL Server Operations
1. Use SQL view to filter only active jobs
2. Convert RTF from resumate to html using stored procedure
Each time Apatar is run, end result is thatOnly active , new jobs are viewed and jobDescription is converted to HTML
SolTech. Inc http://www.soltech.net (404) 601-6000
DNN – Using XmodPro
End Result – How did we get here ?
SolTech. Inc http://www.soltech.net (404) 601-6000
XMOD Pro Template
SolTech. Inc http://www.soltech.net (404) 601-6000
Receive Components
Create receipt lines from initial PO….(or manually)