Go to Treasure Data Catalog, then search and select Salesforce v2.
In the dialog box, enter the values that you enter in your legacy Salesforce connector.
Enter your username (your email) and password, as well as your Client ID, Client Secret and Security Token.
Save Settings and Run the Legacy Salesforce Data Connector One Last Time
You can save your legacy setting from TD Console or from the CLI.
|Table of Contents|
Using TD Console
Save the Settings of Your Scheduled Legacy Salesforce Connector and Run a Final Import
Go to Integration Hub > Sources. Search for your scheduled Salesforce source, select the source and select Edit.
In the dialog box, copy the settings to use later:
Also copy any advanced settings:
Next, you configure one final run with the legacy data connector to create a temporary table against which you can run a config-diff. You use the diff to identify and confirm the latest data imported into Treasure Data.
Before running the final import with the legacy connector, make sure that you change the schedule to one run only:
After the job is complete, look at and copy config_diff in job query information somewhere to use later.
Create New Salesforce V2 Source
Go to Integration Hub > Authentication. Search for new Salesforce v2 connection that you created:
Select the New Source. Fill in all basic settings and advanced settings that you copied in the preceding steps. Then, if you want the new source to continue ingesting from the point where the legacy connector left, fill in the Last Record field with the config_diff information that you copied in the previous job.
After completing the settings, choose the database and table job to populate data into, then schedule the job and provide a name for your new data connector. Select Save and then run the new data connector.
Go to TD Console. Go to Query Editor. Open the Query that uses SFDC for its connection.
Select the SFDC connector, then copy and save the details of the existing connection to use later.
Select DELETE to remove the Legacy one.
In the query, select Output Results. Next, you are going to set up the SFDC v2 connector by finding and select the SFDC v2 export connector that you created.
In Configuration pane, specify the fields you saved in the previous step, then select Done.