IIS 9.1 with MEMSQL DB

DSFreddie · Post by **DSFreddie** » Tue Nov 08, 2016 12:44 pm

Hi All,

I searched the forum to find any posts related to the IIS Datastage connectivity with MEMSQL Database that is currently hot in the market. Can anybody shed some light on how do we establish connectivity between datastage & Memsql DB if you tried it in your projects.

Any thoughts would be helpful.

Thanks
Freddie

chulett · Post by **chulett** » Tue Nov 08, 2016 12:50 pm

I would imagine via ODBC, have you looked into that at all?

And in case this helps:

MemSQL is MySQL wire compatible which means there are many freely available open-source clients, connectors, and development tools that work with MemSQL out of the box. The availability of these tools saves expensive development resources because engineers can focus on critical application programming. Moreover, MemSQL configuration and administration is very similar to MySQL, which means the switch will be easy on your DBAs as well as developers.