Thank you soo much, let me double check every single thing and will let you know soon.
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 > > >>> > > > > > >>> > > > > >>> > > > >>> > > >> > > >
