![]() Hover over the Query Explorer and click the Queries folder to display the query objects in your report.Using the driver's SQL engine ensures that queries will always return up-to-date results, as there is no cached copy of the data. Follow the procedure below to populate a chart with user-defined SQL.Ĭognos will rely on the driver to execute the user-defined query. After a query has been converted to SQL, the UI controls are not available for the query object. When you know the query you need, or if you want to adjust the generated query, convert a query object into an SQL statement. The Rollup Aggregate Function property must be set to Automatic. For this example, override the default by clicking the priority column in the Data Items tab and set the Aggregate Function property to Not Applicable. The column in the Series dimension of the chart is automatically grouped.Īdditionally, Cognos sets a logical default aggregate function for the measure dimension based on the data type. You can populate almost any report object in Cognos with ServiceNow data by simply dragging and dropping columns from the Source Explorer onto the dimensions of the object. To execute queries to the live ServiceNow data, the driver depends on the capabilities of the underlying API. The driver will convert queries into requests to the ServiceNow API. The sections below show how to create a simple report with a chart that shows up-to-date data.Īs you build the report, Cognos Report Studio will generate SQL queries and rely on the driver to execute them. You can now create reports on ServiceNow data in Cognos Report Studio by dragging and dropping table columns from the Source Explorer onto report objects. Click Retrieve Objects and choose the CData ServiceNow database object.Select the ODBC option and enter the DSN, CData ServiceNow Sys, and a user-friendly name. Open Cognos Administration and click Data Source Connections to add a new data source: You can open it with the following command: C:\Windows\sysWOW64\odbcad32.exeĪfter creating a DSN, you can then publish the data source: You will also need to open the 32-bit ODBC Data Source Administrator. If you are running Cognos from a 64-bit machine and want to modify the DSN or create other ServiceNow DSNs, you must use a system DSN. This will limit the number of rows returned, which is especially helpful for improving performance when designing reports and visualizations. When you configure the DSN, you may also want to set the Max Rows connection property. See the "Getting Started" chapter in the help documentation for a guide on connecting to ServiceNow. In addition to the OAuth values, you will need to specify the Instance, Username, and Password connection properties. To authenticate using OAuth, you will need to register an OAuth app with ServiceNow to obtain the OAuthClientId and OAuthClientSecret connection properties. ServiceNow uses the OAuth 2.0 authentication standard. You can use the Microsoft ODBC Data Source Administrator to create and configure ODBC DSNs. This is the last step of the driver installation. ![]() If you have not already, first specify connection properties in an ODBC DSN (data source name). This article describes both a graphical approach to create data visualizations, with no SQL required, as well as how to execute any SQL query supported by ServiceNow. ![]() You can use the CData ODBC driver for ServiceNow to integrate ServiceNow data with the drag-and-drop style of Cognos Report Studio.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |