Talend 6.0 Retrieve Schema

[Anonymous]

Hello,

I am facing issue while  clicking on Retrieve schema from metadata option using access DB in Talend 6.0

New views which are created in access database are not showing in Retrieve Schema therefore its difficult to add those views in Talend Job.

Please look into this issue.

Thanks & Regards

Sanjoy

[Anonymous]

Hello Richard,

Thanks for your reply.

Yes its used to work with 5.6.1 version of Talend but its not working with Talend 6.0.
I haven't used any other version of Talend. Is not it possible to Retrieve Schema from Talend 6.0?
As I don't want to upgrade it to 7.1 version.

Thanks & Regards
Sanjoy

[Anonymous]

Hi Sanjoy,

I think the upgrade is the best route forward for several reasons.

1) v6.0 is quite old now. 

2) v6.0 was a first release for a new major version. It's always a good idea to upgrade to a newer minor release version

3) v7.1 is a stable release, I know this as I use it

Other than the above, the only reason I can suspect for your schema import not working as you say it did in v5.6.1, is that it was a bug in v6.0. I don't have your Access DB to test and I do not have v6.0 on my machine. So the only reasonable suggestion I have, given the information you have offered me, is to suggest the upgrade.

[Anonymous]

Hello Richard,

When I am trying to install Talend 7.1 but I am getting error. I have attached the screenshot of the error.
I don't have Oracle in my machine as I am using access database. I have Windows 10 64bit OS. I have Java 8 installed in my machine.
So could please help me why I am having this error?
I also set environment variable for JAVA_HOME.

Thanks & Regards
Sanjoy

image_2019_02_21T10_37_52_060Z.png
image_2019_02_21T10_37_26_021Z.png
image_2019_02_21T10_36_52_450Z.png

[Anonymous]

You've almost certainly got mismatched versions of Java installed on your machine. Your PATH system variable shows that you have Java installed here...

C:\ProgramData\Oracle\Java\

Your JAVA_HOME variable is pointing to here...

C:\Program Files\Java\jdk1.8.0_101

Your installed programs seems to show Java 1.8.0 update 111.

I cannot tell what version of Java is installed in the ProgramData location. But what you need to solve first is the PATH variable and JAVA_HOME. The JAVA_HOME may well be correct. Test it by going to the folder and exploring. Inside it should have a /jre folder and a /bin folder. If that is the case, you are probably good with that variable. The JRE (java runtime) you wish to use needs to be part of the JDK (so your PATH variable needs to point to the %JAVA_HOME%/jre/bin folder). Your PATH variable must have the first Java folder (first as in left to right) pointing to the Java you want to use for executing the Studio. Essentially, the Java you have recently installed needs to be before any other version of Java in the PATH variable. 

There are ways of enabling multiple versions of Java on your machine, but I suspect you do not need to worry about that at the moment.

[Anonymous]

Hello Richard,

Thanks for your suggestion, I set the JAVA_HOME variable and I am able to open the Talend now but I am not able to import my exisitng project as Finish button is always disabled even after choose the root directory.
I have attached the screenshot of import screen from where I am trying to import the existing project
but I am not able to because finish button is disabled and also getting error "Selected folder is not a Talend Open Studio project", but in this folder I have talend project.

Thanks & Regards
Sanjoy

image_2019_02_22T08_56_08_754Z.png
image_2019_02_22T08_56_24_936Z.png

[Anonymous]

Use the item export in your old version and import the archive that is exported.

https://help.talend.com/reader/EJfmjmfWqXUp5sadUwoGBA/rsZpqQr8vgNyAVHfPmm7XA

[Anonymous]

Hello Richard,

I have export from old version and import in version 7.1 but somehow when I am checking the connection
I am not able to do as its giving me error of missing jar files which I am not able to install.

Thanks & Regards
Sanjoy

image_2019_02_25T06_24_36_483Z.png

[Anonymous]

Download the jars yourself and then use the jar buttons on the right to find them on your system.

You can find jackcess-2.1.0.jar here http://central.maven.org/maven2/com/healthmarketscience/jackcess/jackcess/2.1.0/jackcess-2.1.0.jar

You can find jackcess-encrypt-2.1.0.jar here http://central.maven.org/maven2/com/healthmarketscience/jackcess/jackcess-encrypt/2.1.0/jackcess-enc...

[Anonymous]

Hello Richard,

Thanks for your help, I download the jars now its not showing me jar error.
Now its giving me connection error, but I am not able to edit the connection and change the string of connection.
Could you suggest me how to edit the string connection? As without this I am not able to retrieve schema.

Thanks & Regards
Sanjoy

image_2019_02_26T12_00_55_280Z.png

[Anonymous]

If you get an error, can you post the error? With regard to your metadata settings, you need to press the revert context button.