On Feb 19, 2024, at 3:17â¯AM, Tim Mackinnon <tim@testit.works> wrote:
I do think [GemStone] might have solutions to map to a SQL db to appease corp teams - although I'm not sure.
GemConnect (https://gemtalksystems.com/products/gemconnect/) is an add-on product for GemStone that allows you to interact with an Oracle relational database from GemStone. It is used by several customers to dump transactional data to Oracle for reporting. See also GemConnect-for-Postgres (https://github.com/GemTalk/GemConnect-for-Postgres). Less developed is a way to make GemStone look like a relational database. Years (decades!) ago there was a third-party add-on that allowed marketing to check a box in RFPs but it was never taken seriously. More recently (years, but not decades ago), I did a proof-of-concept that demonstrated connecting Microsoftâs ODBC to GemStone (so you could see GemStone data using SQL. See https://github.com/jgfoster/GemStone-ODBC with links to a silent video and slides. James