Is it possible to enable integration with data stores such as IBM DB2, Microsoft SQL Server and Excel like the Oracle Gateway?

haj · July 23, 2019, 6:44am

Hello,

I have a question regarding integration with other data stores.
Is it possible to enable integration with data stores such as IBM DB2, Microsoft SQL Server and Sybase like the Oracle Gateway?
( External_BreadCrumb )

Thanks

sdew · July 23, 2019, 4:35pm

MemSQL does not have functionality similar to Oracle Gateway at this time.

hanson · July 23, 2019, 4:47pm

Most people who want to integrate data from multiple sources and query it with MemSQL make changes to their applications or write special streaming loaders to bring a replica of the data into MemSQL, and query it inside of MemSQL. For example, it is popular to have a source app, which is updating, say, Oracle or Sybase ASE, also place new records into a Kafka queue, and then have MemSQL load that data from Kafka using MemSQL Pipelines. Alternatively, triggers or some change-data-capture technology can be used on the source system to capture the data for later movement into MemSQL. The data can be brought into MemSQL with standard INSERTs, with Pipelines, or with LOAD DATA.