Skip to main content
To homepage To homepage
Solved

OneLake source

V
Participant

Hello,

TimeXtender: 20.10.31.64
ODX:  20.10.31

We have a case where a customer has to move from SQL database to a OneLake Parquet as the data extraction from one of their systems. We need to find a way to get this data into TimeXtender.

I could find that there is the possibility for one lake parquet connector, but it seems tied to the new version of TX as I can’t find that connector in our version of tx/odx.
 


Is there any possibility for us to do it another way while on our version? 

Thank you,
Victor
 

Best answer by daniel

Dear @Victor ,

As far as I know there is no OneLake connector in te Classic version.

What you could do or try is connect TX to the SQL endpoints in Fabric / the OneLake or kopie / convert the Delta parquets to tables in Fabric and connect to them (through the SQL endpoints).

Hope this helps

= Daniel

 

View original
    devin.tiemens
    O
    W
    3 people like this
    • devin.tiemens
      devin.tiemens
    • O
      Oliverreljanovic
    • W
      WILSP
    Did this topic help you find an answer to your question?

    4 replies

    daniel
    TimeXtender Xpert
    Forum|alt.badge.img+7
    • daniel
    • TimeXtender Xpert
    • 188 replies
    • Answer
    • July 2, 2024

    Dear @Victor ,

    As far as I know there is no OneLake connector in te Classic version.

    What you could do or try is connect TX to the SQL endpoints in Fabric / the OneLake or kopie / convert the Delta parquets to tables in Fabric and connect to them (through the SQL endpoints).

    Hope this helps

    = Daniel

     

    Christian Hauggaard
    V
    2 people like this
    • Christian Hauggaard
      Christian Hauggaard
    • V
      Victor
    Thomas Lind
    Community Manager
    Forum|alt.badge.img+5
    • Thomas Lind
    • Community Manager
    • 1017 replies
    • July 3, 2024

    Hi @Victor 

    If the data is going to be stored in parquet files there also exists a CData parquet provider.

    I am not sure it is a better option than what suggested above, but it should also be able to connect to the data.

    V
    1 person likes this
    • V
      Victor
    V
    Participant
    • Victor
    • Author
    • Participant
    • 18 replies
    • July 3, 2024

    Thank you, will give these a try in the coming weeks.

    rory.smith
    TimeXtender Xpert
    Forum|alt.badge.img+7
    • rory.smith
    • TimeXtender Xpert
    • 649 replies
    • July 4, 2024

    Hi,

    I don't think the CData parquet connector supports parquet stored in OneLake, but only ADLS. As far as I know the interfaces for OneLake are different, so I would not expect it to work.

    Reply


    Most helpful members this week

    Terms and ConditionsCookie settings

    Cookie policy

    We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

     
    Cookie settings