Hello All,
Could any of you advise me why we have JDBC connector stage though we have native stages for any data base and we have ODBC connector for any database for which we dont have native stage with us? We have it because not all database vendors provide ODBC software drivers. Is my understanding correct?
Regards,
Poovalingam.
JDBC Connector
Moderators: chulett, rschirm, roy
-
Poovalingam
- Participant
- Posts: 111
- Joined: Mon Nov 30, 2009 7:21 am
- Location: Bangalore
-
anudeepdasari001
- Participant
- Posts: 58
- Joined: Mon Dec 14, 2015 3:16 pm
- Location: Arizona
I didn't get a chance to use that,
I have a very good understanding why it is used when we have odbc stage,
Here,
It has the ability to connect to the datasource for which we dont have native connector i.e for which there is no ODBC connectivity , like for example Apache Derby.
It uses java connectivity to connect to any data source. It only needs driver class name and the jar file which has this class file in it. The driver class file and the jar file will be same across all the platforms as it is in java, so no platform specific issues.
And also JDBC connector takes URl to connect to any datasource, Which contains datasource name, hostname,port and databse
This information might be useful to you up to some extent,
Thanks
I have a very good understanding why it is used when we have odbc stage,
Here,
It has the ability to connect to the datasource for which we dont have native connector i.e for which there is no ODBC connectivity , like for example Apache Derby.
It uses java connectivity to connect to any data source. It only needs driver class name and the jar file which has this class file in it. The driver class file and the jar file will be same across all the platforms as it is in java, so no platform specific issues.
And also JDBC connector takes URl to connect to any datasource, Which contains datasource name, hostname,port and databse
This information might be useful to you up to some extent,
Thanks
anudpETL