none
Azure Data Factory and the Oracle connector - import schema issue

    Question

  • Hi,

    Using ADF and the Oracle connector, I can access our on premise Oracle database just fine. I create a dataset, select the table and import the schema.

    Does anyone know why the data types that are imported do not match the data types that define the tables in Oracle itself?

    Thanks


    Wednesday, October 17, 2018 6:14 PM

Answers

All replies

  • The imported data types are .net type. The mapping relationship is here
    • Marked as answer by sukhpalsandhu Thursday, October 18, 2018 5:10 PM
    Thursday, October 18, 2018 2:33 AM
  • Thanks.

    That's kind of annoying, especially when my tables have over hundred columns(JD Edwards). I have to manually change them back to what they should be.

    oh well.

    Thursday, October 18, 2018 5:12 PM
  • What do you mean to manually change them back? If just for copy purpose, you should keep it as .net type. 
    Friday, October 19, 2018 2:28 AM