This guide is useful if you want to migrate your Salesforce source from Segment to RudderStack.
Schema Comparison
In this guide, we compare the schemas of the opportunity table synced by RudderStack and Segment.
| RudderStack Columns | Segment Columns |
|---|---|
id | id |
current_generators_c | - |
probability | probability |
context_request_ip | - |
is_deleted | is_deleted |
close_date | close_date |
attributes_url | - |
last_modified_by_id | last_modified_by_id |
context_sources_job_id | - |
context_sources_task_id | - |
channel | - |
name | name |
last_modified_date | last_modified_date |
forecast_category_name | forecast_category_name |
has_opportunity_line_item | has_opportunity_line_item |
system_modstamp | system_modstamp |
forecast_category | forecast_category |
tracking_number_c | - |
attributes_type | - |
is_won | is_won |
lead_source | lead_source |
event_text | - |
timestamp | - |
sent_at | - |
expected_revenue | - |
amount | amount |
created_by_id | created_by_id |
original_timestamp | - |
owner_id | owner_id |
fiscal_year | fiscal_year |
order_number_c | - |
is_private | - |
has_overdue_task | has_overdue_task |
loaded_at | loaded_at |
context_ip | - |
description | description |
event | - |
has_open_activity | has_open_activity |
fiscal | fiscal |
user_id | - |
stage_name | stage_name |
main_competitors_c | - |
context_sources_job_run_id | - |
fiscal_quarter | fiscal_quarter |
type | type |
account_id | account_id |
created_date | created_date |
received_at | received_at |
uuid_ts | uuid_ts |
delivery_installation_status_c | - |
context_sources_task_run_id | - |
is_closed | is_closed |
A blank value indicates that the column was not sent to the platform.
Since the column names are identical for the Salesforce source in both RudderStack and Segment, the migration should not require any additional coding or modification to the tables.
Here's a high-level summary of the number of columns synced to RudderStack, as compared to Segment:
| Columns synced to RudderStack | Columns synced to Segment | Number of common columns | Columns missing in RudderStack | Columns missing in Segment |
|---|---|---|---|---|
| 52 | 30 | 30 | 0 | 22 |
Contact Us
If you come across any issues while migrating your Salesforce source to RudderStack, please feel free to contact us. You can also start a conversation in our Slack community; we will be happy to talk to you!