Topic: Sybase Connection
Sybase Connection
Could you please provide steps to connect to Sybase Database and perform data profiling
Thanks
Ravi
Thanks
Ravi
Hi Ravi,
Hmm upon your request I see that this is actually not very clear how to do it, so first of all I'm going to add an task to my todo-list to make it more obvious :)
What you need to do is:
1) Go to the options window, select the "database drivers" tab and install the JTDS driver.
2) Add a new "database connection" datastore and select the JTDS database type.
3) Enter a connection string like this:
Sorry about the confusion - hope this works though. Please post more questions if you have any.
Hmm upon your request I see that this is actually not very clear how to do it, so first of all I'm going to add an task to my todo-list to make it more obvious :)
What you need to do is:
1) Go to the options window, select the "database drivers" tab and install the JTDS driver.
2) Add a new "database connection" datastore and select the JTDS database type.
3) Enter a connection string like this:
jdbc:jtds:sybase://<server>/<database>(more info about the connection string here: http://jtds.sourceforge.net/faq.html#urlFormat)
Sorry about the confusion - hope this works though. Please post more questions if you have any.
Hi,
I'm experiencing a problem with the Sybase connections. While I can successfully connect to the Sybase DB and pull in the metadata for an object, I am unable to run the jobs or preview the data because it fails with the error below, regardless of using the JDBC-ODBC bridge or the Sybase (net.sourceforge.jtds.jdbc.Driver) drivers. Here is (portion of) the error when using the ODBC:
[DataDirect][ODBC Sybase Wire Protocol driver][SQL Server]The column prefix 'Address' does not match with a table name or alias name used in the query. Either the table is not specified in the FROM clause or it has a correlation name which must be used instead.
And, almost identical error when using the Sybase driver (provided in the dropdown list):
The column prefix '"Address"' does not match with a table name or alias name used in the query. Either the table is not specified in the FROM clause or it has a correlation name which must be used instead.
Any ideas? It seems that the datacleaner's query buider doesn't provide the schema/database owner name.
I'm experiencing a problem with the Sybase connections. While I can successfully connect to the Sybase DB and pull in the metadata for an object, I am unable to run the jobs or preview the data because it fails with the error below, regardless of using the JDBC-ODBC bridge or the Sybase (net.sourceforge.jtds.jdbc.Driver) drivers. Here is (portion of) the error when using the ODBC:
[DataDirect][ODBC Sybase Wire Protocol driver][SQL Server]The column prefix 'Address' does not match with a table name or alias name used in the query. Either the table is not specified in the FROM clause or it has a correlation name which must be used instead.
And, almost identical error when using the Sybase driver (provided in the dropdown list):
The column prefix '"Address"' does not match with a table name or alias name used in the query. Either the table is not specified in the FROM clause or it has a correlation name which must be used instead.
Any ideas? It seems that the datacleaner's query buider doesn't provide the schema/database owner name.
Log in by clicking the login link at the top of the screen
Go back to forum.
