G'day,
Cumbersome title - this area is new to me, so not sure of required keywords.
I have a whole slew of data stored in CSV files. I need to integrate this with data stored in Oracle. I only need to display the results, not update any underlying databases.
At the moment I've created a bufdataset with appropriate fields and am manually cycling along the CSV Dataset, firing off "locates" into a dataset populated from Oracle and populating BufDataset as required. But the code is hideously specific (if Field.Name=ONE Then...). Further down the track I'm interested in integrating data from multiple sources (well, MS SQL, MySQL, Oracle and CSV). This all feels to me like I'm reinventing the wheel.
Searches on here makes me think this is what JanSQL was intended to be designed for. Using SQL to integrate two in memory datasets. Unfortunately looks like development stalled at CSV datasets only.
Does anyone know if any library exists that can help me in it's current state?
Alternatively, does anyone know if JanSQL development has been continued anywhere, or if the implementation in ZMSQL is the latest version?
Many thanks
Mike