<br><b>Code</b>: rsb:print<br><b>Error</b>: Formatter [ rootadoname | tolower() ] failed in the evaluation of <p> Sisense ????????????????????????????????????????????????????????????????????[company_name] JDBC Driver for [service] ???????Sisense ????????[service] ????????????????service ?????ElastiCube ?????ElastiCube ?????Sisense ?[service] ??????????????????? <br><img src="../articles/jdbc-sisense-0.png" title="Sisense ??[service] ???????" width = 700 /> </p> <h2>[service] ???????</h2> <p> Before creating the ElastiCube, note the installation location for the JAR file for the JDBC Driver (typically <i>C:\\Program Files\\CDatat\\CData JDBC Driver for [service]\\lib</i>) or copy the jar file (cdata.jdbc.[rootadoname|tolower].[rootadoname].jar) to a new folder in the Sisense JDBC driver directory (typically <i>C:\\ProgramData\\Sisense\\DataConnectors\\jdbcdrivers</i>). </p> <ol> <li>In the Data page of the Sisense application, create a new ElastiCube (or open an existing one). <li>In the Model Editor, click "+ Data" to open the Add Data dialog box. <li>Click Generic JDBC to open the JDBC settings. <img src='[x|UrlRootAbs]/kb/articles/jdbc-sisense-1.png' title='Connecting via JDBC'/> <li>Set the connection string property to the JDBC URL for [service], adding required properties. [extraconnectionnotesjdbc|def('[extraconnectionnotes|def("")]')] <h4>???????????????</h4> <p>For assistance in constructing the JDBC URL, use the connection string designer built into the [service] JDBC Driver.Either double-click the JAR file or execute the jar file from the command-line.</p> <code> java -jar cdata.jdbc.[rootadoname|tolower].jar </code> <p> Fill in the connection properties and copy the connection string to the clipboard. </p> <img src="[x|UrlRootAbs]/kb/articles/jdbc-url-builder-0.png" title="Using the built-in connection string designer to generate a JDBC URL (Salesforce is shown.)"/> <p> When you configure the JDBC URL, you may also want to set the Max Rows connection property.This will limit the number of rows returned, which is especially helpful for improving performance when designing reports and visualizations. </p> <p> A typical example follows:</p> <code> jdbc:[rootadoname|tolower()]:[extraconnectionprops|def('')]. The error was: The attribute does not exist. This formatter cannot be called with nonexistent attributes.<br><b>URL</b>: /jp/kb/tech/sqlite-jdbc-sisense.rst