Hey guys. I wanted to share an update! I searched...
# singer-tap-development
Hey guys. I wanted to share an update! I searched github for the repo for the progress_sa dialect that @visch pointed out to me. The first result I found was actually a fork of the original repo, found here. It turns out someone made an updated dialect for the newest version of OpenEdge (Progress OpenEdge 11.7), which happened to be exactly what I needed. Using this dialect ended up allowing me to connect to my data source in testing*! Now I have to test this new connection string and dialect in my tap-progress project, and finally bring my tap into my Meltano project and test there. *One small note about installing and setting up this dialect. I had no trouble when following the install instructions in the README of the repo. However, when following the "Usage" instructions I ran into an issue where attempting to run a select script on the database using the newly created engine was returning this error:
Copy code
InterfaceError: (pyodbc.InterfaceError) ('IM002', '[IM002] [unixODBC][Driver Manager]Data source name not found, and no default driver specified (0)
I did some digging and found my resolution here. Super simple fix! Thanks everyone for the suggestions, and I'll update once I've done further testing.