My Requirement: I want to export data from MS Access DB and transfer the data to Oracle DB using talend.
My Problem: I am not understanding clearly how to establish Access DB connection in talend.
Can someone help with this problem. I cant start my data migration activities without understanding how i can establish this connection. Please help me with this problem.
I need to your help with another issue which i am facing right now.
I was able to do all the data export from Test Access DB (which i created) including images and i am able to successfully import it into Oracle DB even the images in BLOB format.
Now the problem is when tried to read the data from the Actual schema in the Access DB and not the test schema which I created it is failing with the below error.
What I am trying to understand here the privilege issue which I am facing now is it related to the privilege of the Schema which i am trying to read or is it anything related to the talend or JDBC privileges.
Please help me with this issue. Below is the error message
WARNING:Error in the metadata of the table Base de dados_Marcas: table's row count in the metadata is 73561 but 73560 records have been found and loaded by UCanAccess. All will work fine, but it's better to repair your database.
WARNING:Error in the metadata of the table Base de dados_Marcas: table's row count in the metadata is 73561 but 2001 records have been found and loaded by UCanAccess. All will work fine, but it's better to repair your database.
Exception in component tDBInput_1 (Image_Extract)
net.ucanaccess.jdbc.UcanaccessSQLException: user lacks privilege or object not found: NULL
at net.ucanaccess.jdbc.UcanaccessDriver.connect(UcanaccessDriver.java:247)
at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:677)
at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:228)
at angola_migrate.image_extract_0_1.Image_Extract.tDBInput_1Process(Image_Extract.java:1757)
at angola_migrate.image_extract_0_1.Image_Extract.runJobInTOS(Image_Extract.java:2716)
at angola_migrate.image_extract_0_1.Image_Extract.main(Image_Extract.java:2554)
Caused by: java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: NULL
