[SOL-179] IMPORT data from Oracle over JDBC Created: 12.09.2014 Updated: 18.09.2020 Resolved: 18.09.2020
|Affects Version/s:||EXASolution 5.0|
|Reporter:||Captain EXASOL||Assignee:||Captain EXASOL|
|Attachments:||EXAoperation_add_Oracle_JDBC.PNG EXAoperation_upload_jar.PNG shutdown-1.png urandom-1.png|
The regular EXASolution installation already contains the Oracle thin JDBC driver preconfigured.
Next upload the Oracle JDBC driver (e.g. ojdbc6.jar):
If you want to achieve best performance, consider to use the native Oracle interface (OCI) which is available through additional license options.
In EXAplus execute the following query to create a connection object in EXASolution:
Test the connectivity by querying the Oracle system catalog, e.g.:
If the query returns a resultset, you are ready to IMPORT some tables.
Now you can IMPORT/EXPORT data from Oracle, e.g.:
If you are getting an "IO Error: connection reset" when trying to import data from Oracle over JDBC
|Category 1:||ETL / Data Integration|
|Comment by Thomas Bestfleisch [ 16.08.2016 ]|
Adding Troubleshooting information