https://datahubproject.io logo
#ingestion
Title
# ingestion
b

brave-pencil-21289

06/08/2022, 1:31 PM
While performing sybaseIQ ingestion I am facing below error file. Can someone help me on this.
d

dazzling-judge-80093

06/08/2022, 1:32 PM
maybe you need the sybase sqlalchemy driver installed? https://pypi.org/project/sqlalchemy-sybase/
b

brave-pencil-21289

06/08/2022, 1:42 PM
I have installed that, but not working
d

dazzling-judge-80093

06/08/2022, 1:54 PM
Can you share your ingestion recipe?
b

brave-pencil-21289

06/08/2022, 2:18 PM
d

dazzling-judge-80093

06/08/2022, 2:20 PM
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

brave-pencil-21289

06/08/2022, 2:21 PM
Is it mandatory to use odbc for sqlalcgemy
d

dazzling-judge-80093

06/08/2022, 2:23 PM
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

brave-pencil-21289

06/08/2022, 2:28 PM
Let me try using odbc driver
b

big-carpet-38439

06/08/2022, 2:36 PM
Also - this source is not officially supported by DataHub. Hence our lack of experience with advising on this one. Just a heads up!
b

brave-pencil-21289

06/09/2022, 3:05 AM
Can some one help me with the download link for sybase odbc driver. Need to use wget command to download the file.
s

square-lawyer-36076

06/13/2022, 11:46 AM
d

dazzling-judge-80093

06/13/2022, 12:18 PM