How to connect to Gmail using TIBCO Data Virtualization Email Adapter with IMAP protocol?

How to connect to Gmail using TIBCO Data Virtualization Email Adapter with IMAP protocol?

book

Article ID: KB0071864

calendar_today

Updated On:

Products Versions
TIBCO Data Virtualization 8.4 and above

Description

This article gives steps to connect with Gmail using the TIBCO Data Virtualization Email adapter with help of the IMAP protocol

Issue/Introduction

This article gives steps to connect with Gmail using the TIBCO Data Virtualization Email adapter with help of the IMAP protocol

Environment

Windows.

Resolution

1) Steps to generate email password:

Create & use App Passwords

If you use 2-Step-Verification and get a "password incorrect" error when you sign in, you can try to use an App Password.

  1. Go to your Google Account.
  2. Select Security.
  3. Under "Signing in to Google," select App Passwords. You may need to sign in. If you don’t have this option, it might be because:
    1. 2-Step Verification is not set up for your account.
    2. 2-Step Verification is only set up for security keys.
    3. Your account is through work, school, or other organization.
    4. You turned on Advanced Protection.
  4. At the bottom, choose Select app and choose the app you using (Gmail) Select device and choose the device you’re using  Generate.
  5. Follow the instructions to enter the App Password. The App Password is the 16-character code in the yellow bar on your device.
  6. Tap Done.

2)  Launch TDV Studio and right click on the folder of choice to create New Data Source.


User-added image

3) In the New Physical Data Source dialog, pick Email and click Next. 


User-added image

 

4) Give Name to the data source and use the following parameters for the connection:

Protocol: IMAP
User: <email_id>
eg. abc@gmail.com
Port: <IMAP_Port>
eg. 993
Server: imap.gmail.com
SMTP Server: smtp.<domain_name>.com
eg. smtp.gmail.com
SMTP Port: 25
Password: Use the earlier generated password.

Additional Information

https://support.google.com/mail/answer/185833?hl=en
https://support.tibco.com/s/article/000049215