嗨,蒂芙尼——你怎么解释的可用性of third party providers who already claim that they can connect Cognos to Power BI? Those companies have apparently developed connectors between ...
See more...
嗨,蒂芙尼——你怎么解释的可用性of third party providers who already claim that they can connect Cognos to Power BI? Those companies have apparently developed connectors between the two enterprise systems. I have heard that data may be transferred to a folder on a regular basis so that the data is available to Power BI, but approach would not provide the accuracy that is required, since data may change, if you can see what I mean. A direct connector with complete connection would provide the most accurate data output, which could leverage all of the data visualization tools available in Power BI. How do you explain the connectors that claim to be offered by third party suppliers? Examples include: Senturus and CDATA. Senturus: https://www.youtube.com/watch?v=Sxkatq3x_JE CDATA: https://www.cdata.com/kb/tech/concur-odbc-power-bi-report-server.rst Here are my concerns regarding third party providers. My concern is that the data would not be equipped with the best security during transit, and that the transactional data and PII information may be "harvested" by the third party connector and processed within the servers for those third party providers. Not a good idea, because of the high level of confidential information and credit card financial information that is available. Not to mention that those third party providers would charge for their connector that would be difficult to sell to potential clients. I would much rather have the connector be supported and authorized by both Concur and Microsoft rather than trusting a third party provider for a connector, By the way, here is a message that was provided by CDATA regarding my inquiry, which in turn raises my concern level: "Our SAP Concur Power BI Connector is not official certified by SAP or Microsoft. I can let you know that the APIs we connect to for Concur require SSL and our drivers in particular will use TLS 1.2 to transmit the data securely. Connections go straight from Concur to your machine and don't pass through CData's servers. We don't currently have any intention of pursuing certification with either SAP or Microsoft at this time, so if this is a requirement for you, we won't be able to provide what you're looking for." Could Concur develop a valid data connector between the Cognos Data Warehouse for which the role of "Cognos Professional Author" must be valid in order to connect to the data with other security mechanisms put in place as well? I have security training/education and would rather utilize an authorized connector between both Concur and Microsoft.