Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

tAccessOutPutBulkExec Component Missing

Hi, i am using Talend Open Studio for Data Integration.

 

According the documentation, this component should be available in the palette in order to allow bulk record commitment.

 

Unfortunaly i am not able to find the Exec Component for MS Access.

 

How can i solve?

 

Thanks,

Labels (3)
1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

Hi,

 

    Please go to File -> Edit Project Properties -> Designer -> Palette Settings and select the Access components to show component list.

0683p000009M6Cu.png

 

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

View solution in original post

4 Replies
Anonymous
Not applicable
Author

Hi,

 

    Please go to File -> Edit Project Properties -> Designer -> Palette Settings and select the Access components to show component list.

0683p000009M6Cu.png

 

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Anonymous
Not applicable
Author

Thanks is worked fine.

 

By the way, i tried to create a simple jobs in order to use the bulk writing function.

 

But i get the error "talend ava.lang.ClassNotFoundException: sun.jdbc.odbc.JdbcOdbcDriver"

 

How can i solve...?

I am able to write to Access DB with the "non-bulk" functions, but for bulks i am struggling this problem...

 

thanks...

 

 

Anonymous
Not applicable
Author

Hi,

 

    You must not have loaded all the necessary jars for the Bulk component. Please check whether there is a yellow ribbon prompting you to install jars under Component view.

 

    If the error persists, please create a new post with screen shot and other details so that Community members can look into it. If we are trying to do everything in single post, it will dilute the focus of the post. Could you please also mark this topic as resolved since your original query has been answered 🙂

 

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Anonymous
Not applicable
Author