While performing sybaseIQ ingestion I am facing be...
# ingestion
b
While performing sybaseIQ ingestion I am facing below error file. Can someone help me on this.
d
maybe you need the sybase sqlalchemy driver installed? https://pypi.org/project/sqlalchemy-sybase/
b
I have installed that, but not working
d
Can you share your ingestion recipe?
b
d
Sqlalchemy says you should have have the odbc driver and set coonection uri like this:
Copy code
<sybase+pyodbc://scott:tiger@your_dsn>
https://github.com/gordthompson/sqlalchemy-sybase#getting-started
b
Is it mandatory to use odbc for sqlalcgemy
d
I don’t know, this driver says this. Sqlalchemy has this disclamer which points to this driver.
Copy code
The Sybase dialect within SQLAlchemy is not currently supported. It is not tested within continuous integration and is likely to have many issues and caveats not currently handled. Consider using the external dialect instead.
b
Let me try using odbc driver
b
Also - this source is not officially supported by DataHub. Hence our lack of experience with advising on this one. Just a heads up!
b
Can some one help me with the download link for sybase odbc driver. Need to use wget command to download the file.
s
d