Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Custom Connector Creation

I am attempting to create a custom connector for an ODBC SQL Anywhere server. I used the provided example for a custom ODBC connector and attempted to modify it. When I test it, I repeatedly get the...
Need Help
Icey's avatar
Icey
Community Support
5 years ago

Hi Anonymous ,

 

I know few about Custom Connector. I may not be able to help you in this regard.

But for Direct Query, there are some limitations of data transformations. And to my knowledge, there is no workaround unless connection mode is switched to Import.

 

 

Best Regards,

Icey

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Icey's avatar
      Icey
      Community Support
      5 years ago

      Hi Anonymous ,

       

      Glad to hear that. Could you share the sample code with us? We are curious about that.😀 

      And please accept it as solution to your question so that people who may have the same question can get the solution directly.

       

       

       

      Best Regards,

      Icey

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        Yeah, I got it from here: https://github.com/microsoft/DataConnectors/tree/master/samples/ODBC

         

        I copied the SQL sample. I initially was just pasting parts of it into the default custom connector, but then I started over with a fresh download of their whole sample and just made the changes I needed.