topic Re: Talend 6.0 Retrieve Schema in Talend Data Catalog

Talend 6.0 Retrieve Schema

Anonymous — Thu, 14 Feb 2019 09:18:02 GMT

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

Re: Talend 6.0 Retrieve Schema

Anonymous — Fri, 15 Feb 2019 10:47:07 GMT

Hi Sanjoy,

I take it you followed some instructions like these (https://help.talend.com/reader/NCvLSgL85zqYq7YwX3T3jQ/mJhFJfBD9OObclJX6d~~XQ)? Did you tick the TABLE, VIEW and SYNONYM tick boxes?

Regards

Richard

Re: Talend 6.0 Retrieve Schema

Anonymous — Mon, 18 Feb 2019 06:07:21 GMT

Hello Richard,

Thank you for your response.

I have done the same way, the way its being mentioned in the link. But I am not able to get the newly created view.
I am attaching you the screenshot. Please kindly look into this. I am using Talend 6.0 version and access database.

Thanks & Regards
Sanjoy

1.png
2.png
3.png

Re: Talend 6.0 Retrieve Schema

Anonymous — Mon, 18 Feb 2019 11:34:34 GMT

Are there ANY differences between R_Transform and R_Transform_CalculDate? Look at things like the permissions on the user you use to view the views/tables in Access and the user used for Talend (if they are different users).

Also, I am assuming the views have been created before you open the connection to the Access database within Talend?

Re: Talend 6.0 Retrieve Schema

Anonymous — Mon, 18 Feb 2019 13:18:10 GMT

Hello Richard,

Yes I am getting error of user permission. But I am able to see the view R_transform_CalculDate and R_TRANSFORM_FORMATDATE_LENGHT
under view schema in Talend so why I am getting this error 'user lacks privilage or object not found'. And when I am trying to
retrieve the schema of those then also I am not able to do as its not showing in the list of schemas.
R_tansform and R_transform_CalculDate are different view.
I am attaching the screenshot of error. How will I get to know what is the user of these views in Talend?

Thanks for looking into my issue.

Best Regards
Sanjoy

1.png
2.png
3.png

Re: Talend 6.0 Retrieve Schema

Anonymous — Mon, 18 Feb 2019 15:22:12 GMT

R_Transform_FormatDate_Length appears to be owned by the Admin user. Are you retrieving the schema in Talend with the Admin user? When you create your metadata connection to the Access database, that user must have access to the tables/views

Re: Talend 6.0 Retrieve Schema

Anonymous — Tue, 19 Feb 2019 06:59:09 GMT

Hello Richard,

Thank you so much for the help. Can please tell me the below query->

How will I check that when I retrieve schema it has admin user or not in Talend? From where I can check this?

Thanks & Regards
Sanjoy

Re: Talend 6.0 Retrieve Schema

Anonymous — Tue, 19 Feb 2019 09:41:45 GMT

When you create your Access DB connection in Talend, you use a username and password. The username must have permissions to see everything you want to retrieve from the database.

Re: Talend 6.0 Retrieve Schema

Anonymous — Tue, 19 Feb 2019 13:12:19 GMT

Hello Richard,

I have all access to retrieve data from access database as the connection done with Talend are old and earlier its used to work on Talend version 5.6.1 but after change the version of Talend 5.6.1 to Talend 6.0, I am not able to retrieve the schema where as that view R_TRANSFORM_FORMATDATE_LENGHT is showing in the list of view schema but when I am trying to access this view from job its giving me error of user lacks privilage or object not found.

I have already shared you the screenshot of those images in my earlier post.

Thanks & Regards
Sanjoy

Re: Talend 6.0 Retrieve Schema

Anonymous — Tue, 19 Feb 2019 14:48:20 GMT

So you are using exactly the same credentials as you were using with the v5.6.1? It worked in v5.6.1? Now with v6.0, it is no longer working? Have you tried a subsequent version of Talend? v7.1.1 is stable release which is currently available.

Re: Talend 6.0 Retrieve Schema

Anonymous — Wed, 20 Feb 2019 09:20:36 GMT

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

Re: Talend 6.0 Retrieve Schema

Anonymous — Wed, 20 Feb 2019 11:22:12 GMT

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.

Re: Talend 6.0 Retrieve Schema

Anonymous — Thu, 21 Feb 2019 12:17:30 GMT

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

Re: Talend 6.0 Retrieve Schema

Anonymous — Thu, 21 Feb 2019 13:41:04 GMT

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.

Re: Talend 6.0 Retrieve Schema

Anonymous — Fri, 22 Feb 2019 09:52:13 GMT

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

Re: Talend 6.0 Retrieve Schema

Anonymous — Fri, 22 Feb 2019 10:09:04 GMT

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

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

Re: Talend 6.0 Retrieve Schema

Anonymous — Mon, 25 Feb 2019 08:37:53 GMT

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

Re: Talend 6.0 Retrieve Schema

Anonymous — Mon, 25 Feb 2019 10:55:29 GMT

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-encrypt-2.1.0.jar

Re: Talend 6.0 Retrieve Schema

Anonymous — Wed, 27 Feb 2019 07:09:36 GMT

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

Re: Talend 6.0 Retrieve Schema

Anonymous — Wed, 27 Feb 2019 09:42:38 GMT

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