There are many databases on the market, but most of them are categorized into three data models relational, document, and graph. Data models and characteristics of the application to store and retrieve data are the factors to choose databases, and we do not compare which one is better. Very clear that the document model is the best for use cases where data is self-contained documents and no relationships of many-to-one or many-to-many between documents. The graph model is the opposite, and it targets to use cases where the data relationship is more complicated.
March 30, 2020
March 10, 2020
Doing data integration with Salesforce is not simple. We have to understand API objects which are analogous to database tables and KSQL to extract data from Salesforce, and different types of API set and when to use appropriately, and the concept of External Id… and limit of API calls.
February 26, 2020
Confluent Schema Registry stores Avro schemas for Kafka producer and consumer so that producers write data with a schema that can be read by consumers even as producers and consumers evolve their using schema.
February 17, 2020
Neo4j is a graph database designed to treat the relationships between data as equally important to the data itself. Neo4j natively supports relationships is able to store, process, and query connections efficiently. While other databases compute relationships at query time through expensive JOIN operations, a graph database stores connections alongside the data in the model.
December 16, 2019
Apache Pulsar is a distributed open source Publication/Subscription based messaging system developed at Yahoo. Pulsar is considered as an alternative to Kafka because of the key features below. Advantco releases an adapter to enable out of the box integration with a Pulsar broker.
October 22, 2019
Advantco is excited to announce that an international non-profit organization has chosen our Salesforce Adapter to meet their technology integration requirements.
October 03, 2019
When consuming grpc services, SAP PO acts like gRPC a client application calling methods on a server application on a different machine. The server application can be a internal developed microservice or a cloud service like Google Pub/Sub.
September 24, 2019
There are use cases where one has to publish huge volume of data from SAP HANA to Salesforce, this blog describes options that are available with the Advantco Salesforce adapter for SDI. We describe how to use virtual tables to upsert (update/create) standard or custom objects in Salesforce. We will also handle platform events in case of more complex use cases where one has parent and child objects.
September 10, 2019
Amazon Simple Queue Service (SQS) is a fully managed message queuing service that enables you to decouple and scale microservices, distributed systems, and serverless applications. To integrate SQS with a HANA database, Advantco developed an adapter SQS for SAP Smart Data Integration(SDI). The adapter enables bi-directional data exchanges between HANA databases and AWS SQS. This blog details the steps required to replicate data from a SQS queue to a HANA real table.
September 09, 2019
In this post, we will go through a scenario where we use Google Cloud Platform (GCP) serverless services to archive Event-Driven model.
August 08, 2019
Amazon Web Services (AWS) is the most broadly adopted cloud platform with a global infrastructure.
August 07, 2019
One of America’s largest energy transportation companies has teamed up with Advantco to integrate their Salesforce and SAP environments with Advantco’s SFDC Adapter.