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 > > >>> > > > > > >>> > > > > >>> > > > >>> > > >> > > >
