Relational Junction

Relational Junction

(15)
4.0 out of 5 stars

Data Replication and Integration

Work for Relational Junction?

Learning about Junction?

We can help you find the solution that fits you best.

Relational Junction Reviews

Ask Junction a Question
Write a Review
Filter Reviews
Filter Reviews
  • Ratings
  • Company Size
  • User Role
  • User Industry
  • For Category
Ratings
Company Size
User Role
User Industry
For Category
Showing 15 Junction reviews
LinkedIn Connections
Junction review by <span>Sam F.</span>
Sam F.
Validated Reviewer
Verified Current User
Invitation from G2 Crowd on behalf of the vendor
Reviewed On

RelationalJunction is the perfect tool for raw data backup and syncronization

What do you like best?

Very little configuration is needed to replicate all Salesforce data to a local SQL server. Custom objects added in Salesforce are automatically added as new tables in the replicated database. Custom fields added in Salesforce are automatically added as new columns in the replicated database.

Configuration files make it easy to configure replication, such as excluding certain objects, how often to replicate each object, etc.

Logs are very verbose. They can be very long, but when something isn't working right, they are very helpful in figuring out exactly what is causing the problem.

Records that are deleted in Salesforce stay in the replicated database forever.

Two way replication is easy. Records can be inserted or changed locally and uploaded to Salesforce simply by flagging the new or updated rows with an 'I' or 'U'. You can also delete records by flagging them with a 'D'.

Besides a browser based user interface, it also has a command line interface. Those familiar with the command line will appreciate the ability to run any task from the command line.

What do you dislike?

If a field type is changed in Salesforce (like from an integer to a text field), Relational Junction will not automatically change the column in the local database. Instead, the replication script will fail until the column is fixed. To do this, you have to delete the column, then run some commands to have Relational Junction add the column again with the correct data type.

Recommendations to others considering the product

If you just want raw data, RelationalJunction is easy to use and fully functional. If you need ETL tools, and the ability to manage what data gets replicated where, this tool will not do it for you.

What business problems are you solving with the product? What benefits have you realized?

Relational Junction provides is with a local backup of all of our Salesforce data. Reporting on Salesforce data is also faster and easier when the data is in a local database.

Sign in to G2 Crowd to see what your connections have to say about Relational Junction
Headshots
Junction review by <span>Pete C.</span>
Pete C.
Validated Reviewer
Verified Current User
Invitation from G2 Crowd on behalf of the vendor
Reviewed On

Great product for working with your Salesforce data

What do you like best?

It's super configurable so we have very granular control over which fields get synced between Salesforce and the database, in which direction, and how often. And I can manipulate the data in the database and sync it back to Salesforce much more easily that I could have performed the same manipulation in Salesforce directly.

What do you dislike?

I'm not that keen on the GUI provided but it's completely configurable via command line and config files, which I prefer anyway, so I'm happy.

Recommendations to others considering the product

It can be a little complex to set up but it's very powerful; I tried other solutions and this is by far the best and most flexible. Their support is OUTSTANDING if you ever have and issue or just need a little guidance. They really do stand behind the product and are very responsive.

What business problems are you solving with the product? What benefits have you realized?

Simply being able to access and manipulate our Salesforce data in a relational database has made a world of difference to us. Salesforce is great for lots of things, but a general purpose database it isn't. Relational Junction bridges the two worlds very, very nicely.

What On-Premise Data Integration solution do you use?

Thanks for letting us know!
Junction review by Executive Sponsor
Executive Sponsor
Validated Reviewer
Verified Current User
Invitation from G2 Crowd on behalf of the vendor
Reviewed On

Releasing data from the cloud into RDBMS

What do you like best?

The access to NetSuite data in raw data form beats the hell out of using the NetSuite API in terms of both performance and flexibility. As far as I know, Relational Junction has the only solution out there that will allow you to back up all your NetSuite objects and data into a relational database. That capability helps us not only with reporting, but also with compliance around DR for larger customers.

What do you dislike?

Inconsistent turn around on issues from support - there are only a few people in the company and only one or two who write the code and support the product, so it can take a good deal of time to solve issues.

Recommendations to others considering the product

If you need a full BI layer, RJ4NS is not the product for you - this tool allows you to back up all your NS objects into a relational database then query them with as many parameters as you can specify via SQL. You still have to do the transformation of this data into actionable information.

What business problems are you solving with the product? What benefits have you realized?

Reporting on key performance indicators and financial performance across numerous record types, which is not possible in Native NetSuite. Before we implemented Relational Junction for NetSuite (RJ4NS), there was not way for us to tie together related data that spanned more than two record types. Saved searches were not getting it done for us. RJ4NS allowed us to automate our EDI billing, to provide actionable intelligence to our office managers across the company for day to day operations, and, to develop customer profiles that we can use for sales and marketing to increase revenue.

Junction review by Administrator in Professional Training & Coaching
Administrator in Professional Training & Coaching
Validated Reviewer
Verified Current User
Invitation from G2 Crowd on behalf of the vendor
Reviewed On

Relational Junction sync with Salesforce

What do you like best?

1. The Relational Junction setup and interface is very easy to use. I've been able to apply filter for uploading to ensure certain fields are not updated, schedule downloads to highly used objects are more frequently updated while less critical objects and my ability to manage the database as needed for my business.

2. The audit feature is AMAZING. I have a ton of certainty that all the data has been processed and when we have issues the audit function cleans up the discrepancies.

3. The price is very affordable when looking at other options like Heroku

What do you dislike?

The notifications when the system hangs (doesn't have any errors) is lacking. I would like to have the ability to set a timeframe that the system should be in "running" mode. If the time is exceeded I should get a notification so I can login and make sure the system isn't having issues.

Recommendations to others considering the product

Pricing, pricing, pricing. RJ is feature rich with a low annual cost overhead.

What business problems are you solving with the product? What benefits have you realized?

RJ has allowed us to process the sales processed in Salesforce without the fear of data loss. Before we used the Salesforce API which could get behind or sync transactions out of order. Additionally the core analytics of Salesforce just didn't meet our needs. This product provides access to the data so we can use on our systems to generate reports and analysis.

Junction review by User in Non-Profit Organization Management
User in Non-Profit Organization Management
Validated Reviewer
Verified Current User
Invitation from G2 Crowd on behalf of the vendor
Reviewed On

Relational Junction Review

What do you like best?

I really like that it gives us direct access to our NetSuite data. Sometimes it is much quicker and convienient to query the data instead of building native reports or saved searches.

What do you dislike?

I wish we could write back to NetSuite instead of it just being a one-way sync. I have heard that they might have something in the works that will allow us to make changes to NetSuite.

What business problems are you solving with the product? What benefits have you realized?

We recently used Relation Junction's copy of our NetSuite database as the source of our data migration efforts to our new CRM system Salesforce. We were able to build SQL scripts to pull the data out of the RJ database and populate it in Salesforce directly. It made the migration task much simpler and organized.

Junction review by Executive Sponsor in Executive Office
Executive Sponsor in Executive Office
Validated Reviewer
Invitation from G2 Crowd on behalf of the vendor
Reviewed On

Use RJ4SF for Data Integration

What do you like best?

There are a few good features with the products but there are now many products out there that are far more compelling and effective.

What do you dislike?

Management team is a joke- poor company culture and they have no respect for customers and do not take responsibilities for their inferior product quality. Some of our team members have tried to contact them for serious production issues and they didn't bother to respond until it's almost renewal time.

According to their CEO, their CTO is also a developer who at times breaks the products in a haste to fix a problem. Quality isn't a strong suit.

Our support team spends insane amount of time addressing data integrity issues caused by the integration tool on a daily basis.

Recommendations to others considering the product

Company culture, service and price. RJ4SF is a finicky product and very expensive. There are a lot of great products out there that are far more mature and much more superior customer support at a lower cost.

What business problems are you solving with the product? What benefits have you realized?

Direct and frequent data integrations for apps and backend DB.

* We monitor all Relational Junction reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. Validated reviews require the user to submit a screenshot of the product containing their user ID, in order to verify a user is an actual user of the product.