October 2018 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-5503) Create or change ODBC driver to be compatible with Microsoft Power BI

by Andrea Modesto Rossi (Jira)

[ https://issues.jboss.org/browse/TEIID-5503?page=com.atlassian.jira.plugin... ] Andrea Modesto Rossi edited comment on TEIID-5503 at 10/12/18 3:44 AM: ----------------------------------------------------------------------- PowerBI supports both ODBC and Odata connection method (as per [1] )meaning that there is a basic integration that already works out of the box. Regardless the Driver, PowerBI supports 2 connection methods [2]: # Import # DirectQuery Both ODBC and Odata are 100% compliant with method 1), both neither ODBC nor Odata works in DirectQuery mode [3]. One Option, and this is the RFE goal, is to extend the capability of the existing ODBC driver according to Microsoft GuideLine: * https://docs.microsoft.com/en-us/power-query/odbc * https://github.com/Microsoft/DataConnectors * https://github.com/Microsoft/DataConnectors/blob/master/docs/m-extensions.md Moreover, it will be really usefull to turn Custom ODBC Driver into a certified Driver that will appear in PowerBI Menu:: Get Data :: DataBase. *Having a CustomDriver [4] is not a solution for Enterprise * Hope this can help. --- [1] https://docs.microsoft.com/en-us/power-bi/desktop-data-sources [2] https://docs.microsoft.com/en-us/power-bi/desktop-directquery-about [3] https://docs.microsoft.com/en-us/power-bi/desktop-directquery-data-sources [4] https://docs.microsoft.com/en-us/power-query/startingtodevelopcustomconne... (Restricted to jira-users group) was (Author: amrossi): PowerBI supports both ODBC and Odata connection method (as per [1] )meaning that there is a basic integration that already works out of the box. Regardless the Driver, PowerBI supports 2 connection methods [2]: # Import # DirectQuery Both ODBC and Odata are 100% compliant with method 1), both neither ODBC nor Odata works in DirectQuery mode [3]. One Option, and this is the RFE goal, is to extend the capability of the existing ODBC driver according to Microsoft GuideLine: * https://docs.microsoft.com/en-us/power-query/odbc * https://github.com/Microsoft/DataConnectors * https://github.com/Microsoft/DataConnectors/blob/master/docs/m-extensions.md Hope this can help. Moreover, it will be really usefull to turn Custom ODBC Driver into a certified Driver that will appear in PowerBI Menu:: Get Data :: DataBase. *Having a CustomDriver [4] is not a solution for Enterprise * --- [1] https://docs.microsoft.com/en-us/power-bi/desktop-data-sources [2] https://docs.microsoft.com/en-us/power-bi/desktop-directquery-about [3] https://docs.microsoft.com/en-us/power-bi/desktop-directquery-data-sources [4] https://docs.microsoft.com/en-us/power-query/startingtodevelopcustomconne... (Restricted to jira-users group) > Create or change ODBC driver to be compatible with Microsoft Power BI > --------------------------------------------------------------------- > > Key: TEIID-5503 > URL: https://issues.jboss.org/browse/TEIID-5503 > Project: Teiid > Issue Type: Feature Request > Components: ODBC > Reporter: Debbie Steigner > Assignee: Steven Hawkins > Priority: Major > > Customer request to customise the ODBC driver, adding extra feature as reported here: https://docs.microsoft.com/en-us/power-query/odbc -- This message was sent by Atlassian Jira (v7.12.1#712002)

6 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5503) Create or change ODBC driver to be compatible with Microsoft Power BI

by Andrea Modesto Rossi (Jira)

[ https://issues.jboss.org/browse/TEIID-5503?page=com.atlassian.jira.plugin... ] Andrea Modesto Rossi edited comment on TEIID-5503 at 10/12/18 3:43 AM: ----------------------------------------------------------------------- PowerBI supports both ODBC and Odata connection method (as per [1] )meaning that there is a basic integration that already works out of the box. Regardless the Driver, PowerBI supports 2 connection methods [2]: # Import # DirectQuery Both ODBC and Odata are 100% compliant with method 1), both neither ODBC nor Odata works in DirectQuery mode [3]. One Option, and this is the RFE goal, is to extend the capability of the existing ODBC driver according to Microsoft GuideLine: * https://docs.microsoft.com/en-us/power-query/odbc * https://github.com/Microsoft/DataConnectors * https://github.com/Microsoft/DataConnectors/blob/master/docs/m-extensions.md Hope this can help. Moreover, it will be really usefull to turn Custom ODBC Driver into a certified Driver that will appear in PowerBI Menu:: Get Data :: DataBase. *Having a CustomDriver [4] is not a solution for Enterprise * --- [1] https://docs.microsoft.com/en-us/power-bi/desktop-data-sources [2] https://docs.microsoft.com/en-us/power-bi/desktop-directquery-about [3] https://docs.microsoft.com/en-us/power-bi/desktop-directquery-data-sources [4] https://docs.microsoft.com/en-us/power-query/startingtodevelopcustomconne... (Restricted to jira-users group) was (Author: amrossi): PowerBI supports both ODBC and Odata connection method (as per [1] )meaning that there is a basic integration that already works out of the box. Regardless the Driver, PowerBI supports 2 connection methods [2]: # Import # DirectQuery Both ODBC and Odata are 100% compliant with method 1), both neither ODBC nor Odata works in DirectQuery mode [3]. One Option, and this is the RFE goal, is to extend the capability of the existing ODBC driver according to Microsoft GuideLine: * https://docs.microsoft.com/en-us/power-query/odbc * https://github.com/Microsoft/DataConnectors * https://github.com/Microsoft/DataConnectors/blob/master/docs/m-extensions.md Hope this can help. --- [1] https://docs.microsoft.com/en-us/power-bi/desktop-data-sources [2] https://docs.microsoft.com/en-us/power-bi/desktop-directquery-about [3] https://docs.microsoft.com/en-us/power-bi/desktop-directquery-data-sources (Restricted to jira-users group) > Create or change ODBC driver to be compatible with Microsoft Power BI > --------------------------------------------------------------------- > > Key: TEIID-5503 > URL: https://issues.jboss.org/browse/TEIID-5503 > Project: Teiid > Issue Type: Feature Request > Components: ODBC > Reporter: Debbie Steigner > Assignee: Steven Hawkins > Priority: Major > > Customer request to customise the ODBC driver, adding extra feature as reported here: https://docs.microsoft.com/en-us/power-query/odbc -- This message was sent by Atlassian Jira (v7.12.1#712002)

6 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5503) Create or change ODBC driver to be compatible with Microsoft Power BI

by Andrea Modesto Rossi (Jira)

[ https://issues.jboss.org/browse/TEIID-5503?page=com.atlassian.jira.plugin... ] Andrea Modesto Rossi edited comment on TEIID-5503 at 10/12/18 3:36 AM: ----------------------------------------------------------------------- PowerBI supports both ODBC and Odata connection method (as per [1] )meaning that there is a basic integration that already works out of the box. Regardless the Driver, PowerBI supports 2 connection methods [2]: # Import # DirectQuery Both ODBC and Odata are 100% compliant with method 1), both neither ODBC nor Odata works in DirectQuery mode [3]. One Option, and this is the RFE goal, is to extend the capability of the existing ODBC driver according to Microsoft GuideLine: * https://docs.microsoft.com/en-us/power-query/odbc * https://github.com/Microsoft/DataConnectors * https://github.com/Microsoft/DataConnectors/blob/master/docs/m-extensions.md Hope this can help. --- [1] https://docs.microsoft.com/en-us/power-bi/desktop-data-sources [2] https://docs.microsoft.com/en-us/power-bi/desktop-directquery-about [3] https://docs.microsoft.com/en-us/power-bi/desktop-directquery-data-sources (Restricted to jira-users group) was (Author: amrossi): PowerBI supports both ODBC and Odata connection method (as per [1] )meaning that there is a basic integration that already works out of the box. Regardless the Driver, PowerBI supports 2 connection methods [2]: # Import # DirectQuery Both ODBC and Odata are 100% compliant with method 1), both neither ODBC nor Odata works in DirectQuery mode [3]. One Option, and this is the RFE goal, is to extend the capability of the existing ODBC driver according to Microsoft GuideLine: * https://docs.microsoft.com/en-us/power-query/odbc * https://github.com/Microsoft/DataConnectors * https://github.com/Microsoft/DataConnectors/blob/master/docs/m-extensions.md Hope this can help. --- [1] https://docs.microsoft.com/en-us/power-bi/desktop-data-sources [2] https://docs.microsoft.com/en-us/power-bi/desktop-directquery-about [3] https://docs.microsoft.com/en-us/power-bi/desktop-directquery-data-sources > Create or change ODBC driver to be compatible with Microsoft Power BI > --------------------------------------------------------------------- > > Key: TEIID-5503 > URL: https://issues.jboss.org/browse/TEIID-5503 > Project: Teiid > Issue Type: Feature Request > Components: ODBC > Reporter: Debbie Steigner > Assignee: Steven Hawkins > Priority: Major > > Customer request to customise the ODBC driver, adding extra feature as reported here: https://docs.microsoft.com/en-us/power-query/odbc -- This message was sent by Atlassian Jira (v7.12.1#712002)

6 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5503) Create or change ODBC driver to be compatible with Microsoft Power BI

by Andrea Modesto Rossi (Jira)

[ https://issues.jboss.org/browse/TEIID-5503?page=com.atlassian.jira.plugin... ] Andrea Modesto Rossi edited comment on TEIID-5503 at 10/12/18 3:36 AM: ----------------------------------------------------------------------- Here a good link that describe what DirectQuery is: * https://docs.microsoft.com/en-us/power-bi/desktop-use-directquery and: * https://docs.microsoft.com/en-us/power-bi/desktop-directquery-about * https://docs.microsoft.com/en-us/power-bi/desktop-use-directquery * https://docs.microsoft.com/en-us/power-bi/desktop-directquery-data-sources Regarding Custom ODBC Driver, From Microsoft Official Documentation, PowerBI fully support Custom ODBC Driver according to the following link: * https://docs.microsoft.com/en-us/power-query/odbc * https://github.com/Microsoft/DataConnectors *https://github.com/Microsoft/DataConnectors/blob/master/docs/m-extensions.md (Restricted to jira-users group) was (Author: amrossi): Here a good link that describe what DirectQuery is: * https://docs.microsoft.com/en-us/power-bi/desktop-use-directquery and: * https://docs.microsoft.com/en-us/power-bi/desktop-directquery-about * https://docs.microsoft.com/en-us/power-bi/desktop-use-directquery * https://docs.microsoft.com/en-us/power-bi/desktop-directquery-data-sources Regarding Custom ODBC Driver, From Microsoft Official Documentation, PowerBI fully support Custom ODBC Driver according to the following link: * https://docs.microsoft.com/en-us/power-query/odbc * https://github.com/Microsoft/DataConnectors *https://github.com/Microsoft/DataConnectors/blob/master/docs/m-extensions.md > Create or change ODBC driver to be compatible with Microsoft Power BI > --------------------------------------------------------------------- > > Key: TEIID-5503 > URL: https://issues.jboss.org/browse/TEIID-5503 > Project: Teiid > Issue Type: Feature Request > Components: ODBC > Reporter: Debbie Steigner > Assignee: Steven Hawkins > Priority: Major > > Customer request to customise the ODBC driver, adding extra feature as reported here: https://docs.microsoft.com/en-us/power-query/odbc -- This message was sent by Atlassian Jira (v7.12.1#712002)

6 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5503) Create or change ODBC driver to be compatible with Microsoft Power BI

by Andrea Modesto Rossi (Jira)

[ https://issues.jboss.org/browse/TEIID-5503?page=com.atlassian.jira.plugin... ] Andrea Modesto Rossi commented on TEIID-5503: --------------------------------------------- PowerBI supports both ODBC and Odata connection method (as per [1] )meaning that there is a basic integration that already works out of the box. Regardless the Driver, PowerBI supports 2 connection methods [2]: # Import # DirectQuery Both ODBC and Odata are 100% compliant with method 1), both neither ODBC nor Odata works in DirectQuery mode [3]. One Option, and this is the RFE goal, is to extend the capability of the existing ODBC driver according to Microsoft GuideLine: * https://docs.microsoft.com/en-us/power-query/odbc * https://github.com/Microsoft/DataConnectors * https://github.com/Microsoft/DataConnectors/blob/master/docs/m-extensions.md Hope this can help. --- [1] https://docs.microsoft.com/en-us/power-bi/desktop-data-sources [2] https://docs.microsoft.com/en-us/power-bi/desktop-directquery-about [3] https://docs.microsoft.com/en-us/power-bi/desktop-directquery-data-sources > Create or change ODBC driver to be compatible with Microsoft Power BI > --------------------------------------------------------------------- > > Key: TEIID-5503 > URL: https://issues.jboss.org/browse/TEIID-5503 > Project: Teiid > Issue Type: Feature Request > Components: ODBC > Reporter: Debbie Steigner > Assignee: Steven Hawkins > Priority: Major > > Customer request to customise the ODBC driver, adding extra feature as reported here: https://docs.microsoft.com/en-us/power-query/odbc -- This message was sent by Atlassian Jira (v7.12.1#712002)

6 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5503) Create or change ODBC driver to be compatible with Microsoft Power BI

by Ramesh Reddy (Jira)

[ https://issues.jboss.org/browse/TEIID-5503?page=com.atlassian.jira.plugin... ] Ramesh Reddy commented on TEIID-5503: ------------------------------------- Looks like Power BI supports OData feeds [1], it that a possible integration scenario with Teiid? [1] https://docs.microsoft.com/en-us/power-bi/desktop-connect-odata > Create or change ODBC driver to be compatible with Microsoft Power BI > --------------------------------------------------------------------- > > Key: TEIID-5503 > URL: https://issues.jboss.org/browse/TEIID-5503 > Project: Teiid > Issue Type: Feature Request > Components: ODBC > Reporter: Debbie Steigner > Assignee: Steven Hawkins > Priority: Major > > Customer request to customise the ODBC driver, adding extra feature as reported here: https://docs.microsoft.com/en-us/power-query/odbc -- This message was sent by Atlassian Jira (v7.12.1#712002)

6 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5506) Remove the option of using qualified logins entirely

by Steven Hawkins (Jira)

Steven Hawkins created TEIID-5506: ------------------------------------- Summary: Remove the option of using qualified logins entirely Key: TEIID-5506 URL: https://issues.jboss.org/browse/TEIID-5506 Project: Teiid Issue Type: Quality Risk Reporter: Steven Hawkins Assignee: Steven Hawkins The backwards compatibility flag from TEIID-4442 should be removed as the feature has not been operational for some time. -- This message was sent by Atlassian Jira (v7.12.1#712002)

6 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5491) Provide Benchmarking based upon TPC-DI

by Van Halbert (Jira)

[ https://issues.jboss.org/browse/TEIID-5491?page=com.atlassian.jira.plugin... ] Van Halbert updated TEIID-5491: ------------------------------- Attachment: Screenshot from 2018-10-11 14-20-58.png > Provide Benchmarking based upon TPC-DI > -------------------------------------- > > Key: TEIID-5491 > URL: https://issues.jboss.org/browse/TEIID-5491 > Project: Teiid > Issue Type: Task > Reporter: Steven Hawkins > Assignee: Van Halbert > Priority: Major > Attachments: Screenshot from 2018-10-11 14-20-58.png > > > We should obtain and provide results around TCP-DI from http://www.tpc.org/tpc_documents_current_versions/current_specifications.asp -- This message was sent by Atlassian Jira (v7.12.1#712002)

6 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5491) Provide Benchmarking based upon TPC-DI

by Van Halbert (Jira)

[ https://issues.jboss.org/browse/TEIID-5491?page=com.atlassian.jira.plugin... ] Van Halbert commented on TEIID-5491: ------------------------------------ Here is the [spec doc|http://www.tpc.org/tpc_documents_current_versions/pdf/tpc-di_v1.1.0.pdf] for the TCP DI benchmark. > Provide Benchmarking based upon TPC-DI > -------------------------------------- > > Key: TEIID-5491 > URL: https://issues.jboss.org/browse/TEIID-5491 > Project: Teiid > Issue Type: Task > Reporter: Steven Hawkins > Assignee: Van Halbert > Priority: Major > > We should obtain and provide results around TCP-DI from http://www.tpc.org/tpc_documents_current_versions/current_specifications.asp -- This message was sent by Atlassian Jira (v7.12.1#712002)

6 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5491) Provide Benchmarking based upon TPC-DI

by Ramesh Reddy (Jira)

[ https://issues.jboss.org/browse/TEIID-5491?page=com.atlassian.jira.plugin... ] Ramesh Reddy commented on TEIID-5491: ------------------------------------- IMO, if it exposes any issues we need to fix them in Teiid engine. Having readily runnable test would be good for QE and perf measurement. > Provide Benchmarking based upon TPC-DI > -------------------------------------- > > Key: TEIID-5491 > URL: https://issues.jboss.org/browse/TEIID-5491 > Project: Teiid > Issue Type: Task > Reporter: Steven Hawkins > Assignee: Van Halbert > Priority: Major > > We should obtain and provide results around TCP-DI from http://www.tpc.org/tpc_documents_current_versions/current_specifications.asp -- This message was sent by Atlassian Jira (v7.12.1#712002)

6 years, 2 months

1
0
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues October 2018