When the commercial off-the-shelf connectors do not work
Closed-Won Opportunities
Salesforce to Oracle NetSuite synchronization
When the commercial off-the-shelf connectors do not work
Closed-Won Opportunities
Salesforce to Oracle NetSuite synchronization
Closed-Won Opportunities: Salesforce to Oracle NetSuite Synchronization
Recently we were privileged to work on a Salesforce to NetSuite integration for one of our dear customers. This time our task was to build an Extract-Transform-Load (ETL) system for Closed Won Opportunities data synchronization from Salesforce to Oracle NetSuite (which we will call the Connector).

Our goal was to create a robust custom connector that our customer would own at close to zero monthly associated expenses and burden on the IT department during adoption and product lifetime as opposed to paying expensive monthly subscription or installation fees.
Action
While working on the connector, we were able to add value by finding and resolving multiple data consistency issues. Data consistency issues are among the most expensive and hardest to fix IT problems. Only by carefully analyzing the data and talking to different people within the organization is it possible to build the system that proactively helps to investigate potential data consistency issues and gives enough controls for people to react proactively. Checks for consistency and awareness about data integrity issues were the two free benefits that our customer got with the Connector engine. Perhaps we delivered such exceptional results because we worked so closely with the client's Sales, Finance, and IT departments, collaborating as a single cohesive team. We were sharing ideas and our experiences to provide the best solution that fits perfectly into their business workflows.

When your goal is to deliver predictable results and value to your customer, there is no one-solution-fits-all. Business processes within an organization involve massive amounts of data, many systems working together, and a lot of people in-between. Keeping people away from raw data is probably the best thing the company can do to avoid many headaches.

We can't emphasize the importance of this point enough. Most likely, there is no single person within the organization who knows everything, especially for large scale corporations. That is why it is vital to cooperate and carefully analyze requirements on every stage of the software development lifecycle. Functional requirements may and will change, the specs may miss some of the critical aspects, but that is completely fine. What is essential and the most challenging is to deliver a product in time that solves problems and works predictably with the "bad" data it may consume.

Robust functionality and graceful data processing are not the only vital aspects in such strategically important integration. Proper security controls, logging, operational excellence, as well as awareness of what is happening within the system at any point in time all are crucial aspects as well. Together we learned a lot, shared ideas, and made tremendous improvements.
As a result of our collaboration on the Connector, our customer is now equipped with the robust and predictable Extract-Transform-Load system that gives their personnel an ability to troubleshoot and investigate potential sources of "bad" data, react proactively by improving the data, and mitigate the root cause of the issues.

We would not be able to achieve these results without many people within our customer's multiple departments. A lot of gratitude and appreciation for this project goes to them. I am excited and thankful for the trust and cooperation.

As of this writing, monthly cloud computing fees, for this integration, are around two dollars, expenses associated with the burden on IT are close to zero.
The Connector Under the Hood
Custom-built, near Real-Time Data Processing with an ability to run On-Premises servers OR in the Cloud
Integration with AWS in minutes
The Connector integrates with AWS Fargate in minutes. Robust functionality and graceful data processing are not the only vital aspects in such strategically important integration. Proper security controls, logging, operational excellence, as well as awareness of what is happening within the system at any point in time all are crucial aspects as well.
Data Encryption at REST & In-Transit
Using AWS Key Management Service as a solid base for the data encryption at REST. Utilizing HTTPS protocol to connect to Salesforce and Oracle NetSuite provides secure transport for the data encryption in transit.
Pay per Seconds of Execution
The Connector was designed for cost optimization, embracing expenditure awareness consumption model. By using cost-effective resources, you are paying for what you use, when you use it.
Data Integrity Audit
While working on the Connector, we were able to add value by finding and resolving multiple data consistency issues. Together we learned a lot, shared ideas, and made tremendous improvements.
Secure Logging & Notifications
Secure and lightning-fast synchronization, in seconds you get a feedback during every stage of the synchronization. AWS CloudWatch delivers notifications right to your inbox or Dashboard.
Custom Python Library
We have developed a custom Core Library to connect to Oracle NetSuite via SOAP API. As a result, our customer is now equipped with the robust and predictable Extract-Transform-Load system that gives their personnel the ability to troubleshoot and investigate potential sources of "bad" data, react proactively by improving the data, and mitigate the root cause of issues.
The Shortest Dependency Chain
The Connector can be provisioned to operate in any Python-friendly environment. With the shortest library dependency chain. You can run the Connector at the time and frequency you want.
Are you ready to start building your modern data integration project?



All product names, logos, and brands are property of their respective owners. All company, product and service names used in this website are for identification purposes only. Use of these names, logos, and brands does not imply endorsement.


© 2019 Konstankino LLC. All Rights Reserved.
This site was made on Tilda — a website builder that helps to create a website without any code
Create a website