G2 Crowd gives a real-time look at how dreamforce sponsors and exhibitioners stack up.
Relational Junction

Relational Junction

4.3
(29)

Data Replication and Integration

Work for Relational Junction?

Learning about Relational Junction?

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

Relational Junction Reviews

Ask Relational Junction a Question
Write a Review
Filter Reviews
Filter Reviews
  • Ratings
  • Company Size
  • User Role
  • For Category
  • Industry
Ratings
Company Size
User Role
For Category
Industry
Showing 29 Relational Junction reviews
LinkedIn Connections
Relational Junction review by Sam F.
Sam F.
Validated Reviewer
Verified Current User
Review Source

"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
Relational Junction review by Anil  P.
Anil P.
Validated Reviewer
Verified Current User
Review Source

"Relation Junction for Salesforce"

What do you like best?

Support staff and there dedication towards solving the issue.

Also knowledge of support staff is excellent. They provides information even at one go and issue gets resolved.

Whenever we had call for any issue resolution they solves issues almost in one go.

Secondly tool; but obvious its best tool for saleforce data integration.

What do you dislike?

There is nothing at the moment i have to mention in this section, and hope same going ahead also.

Recommendations to others considering the product

This is best tool for SFDC integration

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

We are using to sync Salesforce data from our in house salesforce instance, if we need to pull data for any additional object which we identified later on also easy to add and syncs data within no time.

So data availability is made as early.

What On-Premise Data Integration solution do you use?

Thanks for letting us know!
Relational Junction review by Pete C.
Pete C.
Validated Reviewer
Verified Current User
Review Source

"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.

Relational Junction review by Abdel Ezer C.
Abdel Ezer C.
Validated Reviewer
Review Source

"Review for Relational Junction"

What do you like best?

Application setup was easy and support has been very helpful. Replicating salesforce data to and from the local database is so simple. Creating config files and replication instances which set up the replication is very easy.

What do you dislike?

Sometimes the replication is slow, sometimes it's not. I think it depends in the setup of the config and replication files. I always ask for the support's help whenever an error comes up. Also, updating tables with changes from their salesforce counterpart (fields, datatype, size) is not easy.

Recommendations to others considering the product

RJ is great and complete product as an ETL tool. Very easy to use and also have a great support. We use RJ to mirror Salesforce and sync data to our SQL. It works great. Whenever you have issues you can ask for the support and they response fast.

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

Transferring of data from Salesforce to our local database is easier, which we can modify or update.

Relational Junction review by Executive Sponsor
Executive Sponsor
Validated Reviewer
Verified Current User
Review Source

"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.

Relational Junction review by Administrator in Professional Training & Coaching
Administrator in Professional Training & Coaching
Validated Reviewer
Verified Current User
Review Source

"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.

Relational Junction review by User in Information Technology and Services
User in Information Technology and Services
Validated Reviewer
Verified Current User
Review Source

"Outstanding tool for replicating salesforce data."

What do you like best?

As a general rule if you have a basic SQL background you should be able to configure and run this application with ease. There is no need to learn a new language.

What do you dislike?

I enjoy most features but the UI could be enhanced with a more responsive design.

Recommendations to others considering the product

For the price point and ease of use, it is tough to beat.

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

We set out with 2 goals. 1. Data replication that would then be used to create SQL based reports that were not possible with basic Salesforce.com reporting. 2. The ability to use SQL tables to push data to Salesforce.com.

Relational Junction review by User in Non-Profit Organization Management
User in Non-Profit Organization Management
Validated Reviewer
Verified Current User
Review Source

"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.

Relational Junction review by Executive Sponsor in Executive Office
Executive Sponsor in Executive Office
Validated Reviewer
Review Source

"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.

Relational Junction review by User in Government Administration
User in Government Administration
Validated Reviewer
Verified Current User
Review Source

"This product is awesome"

What do you like best?

- The synchronization is great

- I love how you can include or exclude certain objects, fields and even record types

- The out of the box features that you get with RJ such as history tracking, logs, delete records are great to have.

- Loads run fast, keeps our downstream DB in sync with our SF environment and audits allow us to detect schema changes

What do you dislike?

- The initial setup takes some time

- Password encryption is a little annoying

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

Instead of making hand written API calls to our SF environment, we have RJ jobs that do all the work for us making it seamless.

Relational Junction review by User in Internet
User in Internet
Validated Reviewer
Review Source

"Reliable Replication from Salesforce to Postgres"

What do you like best?

We have had RJ4Salesforce on our critical path for about 6 years. In that time we have had relatively few problems, and Sesame has always been very responsive to any issues we've had. We've also compared their Real-Time Option for replication with Salesforce's Heroku Connect, which it consistently outperforms. The licensing is pretty reasonable for what we do with it. The software is highly configurable.

What do you dislike?

The software does have its limits. Mass updates of records, which happens when currencies are updated in Salesforce, will slow the software down dramatically. Similarly, the Real-Time Option cannot work with multiple workers.

Recommendations to others considering the product

As always, limiting the number of columns and the number of rows results in best performance.

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

We migrated from a relational database into Salesforce, but were able to avoid modifying the software which read from the relational database.

Relational Junction review by Administrator
Administrator
Validated Reviewer
Verified Current User
Review Source

"Perfect for Salesforce and your data sincro"

What do you like best?

It is simple to use and very powerfull to do any data integration you need

What do you dislike?

I miss a lot to have an option select the next action with the results of the previous one.

Recommendations to others considering the product

It's the best option for data integration when you have salesforce in your company.

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

data integration oracle<-> salesforce, Backup, easy integration with webservices.

Relational Junction review by Alan R.
Alan R.
Validated Reviewer
Review Source

"Great Product for improving efficiency."

What do you like best?

Relational Junction allows me to use the tools I am familiar with (MS SQL) to move data to and from our ERP system. This has greatly improved our efficiency in keeping records in sync between Salesforce and our ERP system.

What do you dislike?

Interface could be a little more user friendly.

Recommendations to others considering the product

Great Product if you are looking to archive your data and want to have it on premise. Also allows you to combine data from different sources to upload to Salesforce.

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

Keeping our ERP and Salesforce systems in sync. Major efficiency benefits in moving data.

Relational Junction review by User in Insurance
User in Insurance
Validated Reviewer
Verified Current User
Review Source

"Helped expand our capabilities"

What do you like best?

We can easily get to Salesforce data for reporting now. Also, once the data was so readily available the programmers started finding lots of uses for the information.

What do you dislike?

Not as much recently but we used to have to wipe out the mirror database and start from scratch to get the software to update the data.

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

- reporting

- apps that need to combine Salesforce data with data from other system(s)

- ad hoc data mining

Relational Junction review by Administrator
Administrator
Validated Reviewer
Verified Current User
Review Source

"Perfect for Salesforce and your data sincro"

What do you like best?

Easy to use and great team support.

We are using this product for a couple of years and it have sincro thousands of millions of rows to and from salesforce to our database.

What do you dislike?

nothing at this point.

We are very happy with this product

Recommendations to others considering the product

Use it asap

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

data integration with our databases and salesforce.

Relational Junction review by Administrator
Administrator
Validated Reviewer
Verified Current User
Review Source

"Salesforce replication"

What do you like best?

Easy to set up and configure and get data down quickly. Compared to SSIS plugin, bringing down very large tables worked very well.

What do you dislike?

User manuals need a bit of improvement. Not much else to dislike.

Recommendations to others considering the product

Great solution.

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

Enable timely reporting on SalesForce data combined with other data from internal systems.

Relational Junction review by Administrator in Education Management
Administrator in Education Management
Validated Reviewer
Review Source

"Relational Junction"

What do you like best?

We needed a tool that would backup and replicate our salesforce database. In researching products, this one seemed to be the most robust.

What do you dislike?

Some of the setup instructions not that straight forward. Once the user interface is explained, it's less confusing to work with.

Recommendations to others considering the product

Make sure to confirm what objects can and cannot be backed up.

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

Salesforce data export is just a set of .zip files, if we were to actually need to find something from a backup, it would be nearly impossible. With RJ, we can query what we need and recover it quickly. Also if you were to need salesforce to help you recover data, you are looking at a heavy cost.

Relational Junction review by Administrator
Administrator
Validated Reviewer
Verified Current User
Review Source

"Nice and convinient tool"

What do you like best?

Really easy to set up and running, great support team that will help with any issue or doubt you may have.

What do you dislike?

Sometimes, bugs are hard to resolve, but again support team will do their best to fix it.

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

Data sync between our in-house database and salesforce data.

Relational Junction review by Administrator in Information Technology and Services
Administrator in Information Technology and Services
Validated Reviewer
Verified Current User
Review Source
View Original

"Relational Junction"

What do you like best?

User doesnt need to worry about data structure/table changes on source and destination. RJ takes care of this automatically.

What do you dislike?

Though the UI is simple, setting up RJ from scratch and getting it up and running is painful.

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

Syncing our SFDC system with SQL Server data warehouse.

Relational Junction review by User
User
Validated Reviewer
Review Source

"Let us take a big leap forward"

What do you like best?

Using Relational Junction to dump our Salesforce data into a SQL databasae let us easily and quickly have it available to report on and to use in our on-line portals.

What do you dislike?

Very occasionally we have to manually refresh the data.

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

Data is now available to all of our programmers, not just the couple of Salesforce folks. It's allowed us to make our commission payments more accurate. It's allowed us to pair Salesforce data with other data and present it on our portals.

Relational Junction review by Andrew R.
Andrew R.
Validated Reviewer
Verified Current User
Review Source

"Data-warehouse Tech Lead"

What do you like best?

Easy configuration and downloading a large amount of data out-of-the-box

What do you dislike?

lack of status, progress in UI. Many places where logs are located

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

Building data warehouse

Relational Junction review by Internal Consultant
Internal Consultant
Validated Reviewer
Review Source

"Excellent product makes easy to integrate with Salesforce"

What do you like best?

You can get a database copy of your Salesforce data without any programming.

What do you dislike?

No too much to say, probably that you need a system administrator, it can't be run by an end user.

Recommendations to others considering the product

Review carefully which data is duplicated between Salesforce and your other systems

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

It makes easy to integrate both cloud and database worlds without any programming. A legacy system can read and write Salesforce data through the replicated data base.

Relational Junction review by Jay P.
Jay P.
Validated Reviewer
Review Source

"Relational Junction "

What do you like best?

Very good product for SFDC data replication. We use it very actively.

What do you dislike?

It hangs sometimes and we have to restart the jobs mid way.

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

SFDC data replication and updates.

Relational Junction review by User in Information Technology and Services
User in Information Technology and Services
Validated Reviewer
Verified Current User
Review Source

"Good"

What do you like best?

It is easy to use and customer support replies actively if you ahvw questions.

What do you dislike?

The tool is sometimes slow depending on the record.

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

Processing feeds

Relational Junction review by Bhupesh K.
Bhupesh K.
Validated Reviewer
Review Source

"Performance wise"

What do you like best?

It's load the data very fast from salesforce

What do you dislike?

Everything is good and it's working very effectively.

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

Data is available to business users very effectively.

Relational Junction review by John M.
John M.
Validated Reviewer
Review Source

"The product works as advertised"

What do you like best?

It makes the transition from SalesForce to reporting tools seemless.

What do you dislike?

That you need to buy a third party product to get data from SalesForce

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

Custom reporting for an application that runs on the SalesForce platform

Relational Junction review by Internal Consultant in Consumer Goods
Internal Consultant in Consumer Goods
Validated Reviewer
Review Source

"Easily integrate with Salesforce"

What do you like best?

Easy to learn and use for our integration between our data warehouse and salesforce

What do you dislike?

We like everything about relational junction.

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

We used RJ to integrate between our data warehouse and Salesforce. It is quick and easy to use.

Relational Junction review by Administrator
Administrator
Validated Reviewer
Review Source

"Can recommend RJ for smaller orgs"

What do you like best?

Syncing meta data and backing up the org meta data.

What do you dislike?

Cannot handle huge orgs which need field history need to be backed up.

Does not scale with free databases like mysql.

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

Metadata and data backup.

Relational Junction review by Administrator
Administrator
Validated Reviewer
Review Source

"Still in use after two years"

What do you like best?

This product was easy to install and configure, and the support staff knowledgeable.

What do you dislike?

The administrative interface was not intuitive.

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

It provides an excellent interface between our users and our datawarehouse

* 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.