I guess your situation maybe similar to this link: - https://dba.stackexchange.com/questions/238135/odbc-error-for-oracle-client-12-2-0-1
Here are some librays that I installed on my PC. (My PC is a single language version, its display language can not change to English.) [image: check-visual-c++-windows.jpeg] ------------------------ With warm regard Xiaoxiang Yu On Wed, Nov 8, 2023 at 4:00 PM Nam Đỗ Duy <na...@vnpay.vn.invalid> wrote: > Hi Xiaoxiang, > > I got this error when configuring the ODBC, it said the dll file was not > found but in fact it is there in the location. Please kindly advise... > > Thank you very much > > [image: image.png] > > On Wed, Nov 8, 2023 at 2:25 PM Xiaoxiang Yu <x...@apache.org> wrote: > >> Hi, >> This morning, I verified the Kyligence ODBC Driver's connectivity >> with Kylin 5.0.0-beta, it works well on my Windows PC, and I can preview >> the table data in the Power BI application correctly. >> >> Here is my PC and software information: >> - PC : A laptop with 4 cores CPU and 16GB RAM >> - OS : Windows 11 Home China Version, 22H2 >> - Kylin : Kylin 5.0.0-beta in docker image(downloaded from dockerhub) >> - Docker Desktop : latest(4.25.0) >> - WSL : latest/ubuntu >> - Power BI Desktop : 2.122.1066.0 64-bit(October 2023) , the latest >> version which download from Microsoft Store >> - ODBC Driver: 3.1.12, visit https://download.kyligence.io/#/download >> , >> find the link of 'Kyligence ODBC Driver for Windows 64 bit', the >> downloaded >> file name should similar to 'Kyligence.ODBC.3.1.12.1008.Windows.x64.exe' >> >> >> Here is how to prepare a Kylin Instance in Windows: >> 1. Install Docker Desktop and WSL, refer >> https://learn.microsoft.com/zh-cn/windows/wsl/tutorials/wsl-containers . >> 2. Execute command( >> https://hub.docker.com/r/apachekylin/apache-kylin-standalone) in WSL >> shell(default is Ubuntu) >> to start Kylin Instance. >> 3. Build a segment of Model 'sample_ssb' and make sure the job >> succeeds. >> 4. Install Power BI Desktop(it is free to use) >> 5. Install and configure Kyligence ODBC Driver, and test the >> connectivity >> 6. 'Get Data' from Power BI Desktop, and preview table rows >> >> >> Here is my configuration of 'ODBC Datasource': >> - Host : 127.0.0.1 >> - Port : 7070 >> - Username : ADMIN >> - Password : KYLIN >> - Project : learn_kylin >> >> Here is my suggestion: >> Unluckily, I didn't have the same software as yours. But I think you >> should >> check if you configured it correctly. >> If you cannot make it correct, please go to 'Kyligence ODBC Driver DSN >> Setup', >> click the 'Logging Options', and set proper Log Level and Log Path. Then >> you >> should retry and check if log files show any helpful message. >> >> Here are some of my screenshots: >> 1. Step 5, ODBC DSN Configuration, >> >> https://kylin.apache.org/images/Kylin-ODBC-DSN/odbc-kylin5-powerbi-desktop-windows-1.jpeg >> 2. Step 6, Power BI Desktop, >> >> https://kylin.apache.org/images/Kylin-ODBC-DSN/odbc-kylin5-powerbi-desktop-windows-2.jpeg >> >> Hope this reply will help you fix your problem. >> >> ------------------------ >> With warm regard >> Xiaoxiang Yu >> >> >> >> On Tue, Nov 7, 2023 at 7:18 PM Nam Đỗ Duy <na...@vnpay.vn.invalid> wrote: >> >> > Hi Xiaoxiang, I downloaded that file but the error is still the same, >> > please kindly investigate and advise me. >> > >> > Thank you very much >> > >> > On Tue, Nov 7, 2023 at 5:15 PM Xiaoxiang Yu <x...@apache.org> wrote: >> > >> > > I need some time to try to reproduce and find the cause, but before >> that, >> > > could you re-download another driver from >> > > https://download.kyligence.io/#/download have >> > > another try ? >> > > ------------------------ >> > > With warm regard >> > > Xiaoxiang Yu >> > > >> > > >> > > >> > > On Tue, Nov 7, 2023 at 5:58 PM Nam Đỗ Duy <na...@vnpay.vn.invalid> >> > wrote: >> > > >> > >> Thank you Xiaoxiang, please see the attached photo and advise me the >> > >> following: >> > >> >> > >> 1. I setup the file of x64, is it correct? >> > >> 2. I run docker kylin 5.0 on Windows 10 Enterprise, mapping port of >> > >> docker to 7070:7070 but it showed error as attached file. please >> advise >> > the >> > >> configuration. >> > >> >> > >> Thank you very much >> > >> >> > >> [image: image.png] >> > >> >> > >> On Tue, Nov 7, 2023 at 4:51 PM Xiaoxiang Yu <x...@apache.org> wrote: >> > >> >> > >>> Oh, you just ignore the 'A running Kyligence Enterprise server', >> since >> > >>> you >> > >>> have a Kylin 5 server, you can replace it with your Kylin 5 server. >> > >>> That is because I know that these two products share the >> > >>> same API, metadata, and the core design . >> > >>> ------------------------ >> > >>> With warm regard >> > >>> Xiaoxiang Yu >> > >>> >> > >>> >> > >>> >> > >>> On Tue, Nov 7, 2023 at 5:40 PM Nam Đỗ Duy <na...@vnpay.vn.invalid> >> > >>> wrote: >> > >>> >> > >>> > Hi Xiaoxiang, >> > >>> > >> > >>> > In order to use Kylin ODBC, do I need to buy separate license of >> > >>> Kyligence >> > >>> > to use it? >> > >>> > >> > >>> > Prerequisites >> > >>> > >> > >>> > 1. >> > >>> > >> > >>> > Microsoft Visual C++ 2015 >> > >>> > >> > >>> > During the installation of Kyligence ODBC Driver, Microsoft >> VC++ >> > >>> will be >> > >>> > installed first and redistributable is already embedded in the >> > >>> > installation >> > >>> > package. If Microsoft Visual C++ 2015 is already installed on >> your >> > >>> > machine, >> > >>> > this step will be skipped. >> > >>> > 2. >> > >>> > >> > >>> > A running Kyligence Enterprise server >> > >>> > >> > >>> > Kyligence ODBC Driver will connect to a Kyligence Enterprise >> > server >> > >>> to >> > >>> > verify whether the connection works, so make sure the Kyligence >> > >>> > Enterprise >> > >>> > is running properly. >> > >>> > >> > >>> > >> > >>> > Thank you and best regards >> > >>> > >> > >>> > On Tue, Nov 7, 2023 at 3:46 PM Xiaoxiang Yu <x...@apache.org> >> wrote: >> > >>> > >> > >>> > > Kylin Team didn't release a suitable driver at the moment, but >> you >> > >>> can >> > >>> > try >> > >>> > > an ODBC >> > >>> > > driver from Kyligence(a vendor of Kylin). I did not verify but I >> > >>> supposed >> > >>> > > it should >> > >>> > > work for 5.0.0-beta. Please let us know if it can meet your >> needs. >> > >>> > > >> > >>> > > Here are the download and document links by its website: >> > >>> > > >> > >>> > > 1. >> > >>> > > >> > >>> >> > >> https://kyligence.io/resources/kyligence-odbc-driver-for-apache-kylin-2/ >> > >>> > > 2. >> > >>> > > >> > >>> > > >> > >>> > >> > >>> >> > >> https://docs.kyligence.io/books/v4.6/en/Analyst-and-Business-Users-Guide/integration/ >> > >>> > > >> > >>> > > >> > >>> > > ------------------------ >> > >>> > > With warm regard >> > >>> > > Xiaoxiang Yu >> > >>> > > >> > >>> > > >> > >>> > > >> > >>> > > On Tue, Nov 7, 2023 at 3:14 PM Nam Đỗ Duy >> <na...@vnpay.vn.invalid> >> > >>> > wrote: >> > >>> > > >> > >>> > > > Dear Sir/Madam >> > >>> > > > >> > >>> > > > Our company is using report server on premise. Please advise >> me >> > the >> > >>> > > > integration guidelines in two scenarios: >> > >>> > > > >> > >>> > > > 1. POC period: >> > >>> > > > Power BI report server: Windows 10 >> > >>> > > > Kylin 5.0 in docker file downloaded from official kylin >> website >> > >>> > > > >> > >>> > > > 2. Development period: >> > >>> > > > Power BI report server: Windows 10 >> > >>> > > > We plan to not use docker this time: Kylin 5.0, Hive, zoo >> keeper, >> > >>> > hadoop >> > >>> > > in >> > >>> > > > Ubuntu >> > >>> > > > >> > >>> > > > Thank you very much and best regards >> > >>> > > > >> > >>> > > >> > >>> > >> > >>> >> > >> >> > >> >
