See Using from Tools shows how to connect to Anzo and query data from several popular database tools. See Executing Statements and Using Prepared Statements to execute SQL statements to Anzo tables. See Connecting from Code to create JDBC Connection objects. The driver models Anzo entities as a relational database, dynamically discovering the schemas to allow access to all of your Anzo sources. To deploy the driver JAR file, you must have Java Development Kit (JDK) 1.6 or higher installed on your system. You can find JSP, console, and swing demos in the installation folder. The CData JDBC Driver for Anzo provides full support for integration into Java applications, including Eclipse, NetBeans, IntelliJ IDEA, and many other Integrated Development Environments, as well as J2EE applications running on a Java server such as Tomcat. The Advanced Settings section shows how to set up more advanced configurations and troubleshoot connection errors. You can also configure driver capabilities through the available Connection properties, from data modeling to firewall traversal. The Connection properties describe the various options that can be used to establish a connection.Įstablishing a Connection shows how to authenticate to Anzo and configure any necessary connection properties in a JDBC URL. See Data Model for information on the available entities and how to query them. See SQL Compliance for a syntax reference and code examples outlining the supported SQL. JDBC remoting is enabled using the popular MySQL wire protocol server. NET, C++, PHP, Python, and so on) and using any standards-based technology (ODBC, JDBC, and so on). The JDBC remoting feature allows hosting the JDBC connection on a server to enable connections from virtually anywhere - various clients on any platform (Java. See JDBC Remoting to configure remote access to the JDBC data source. Query the System Tables to access additional metadata, such as data source capabilities.Īdvanced Features Advanced Features details additional features supported by the driver, such as defining user defined views, ssl configuration, remoting, caching, firewall/proxy settings, and advanced logging. See Schema Discovery to access schema information through the standard JDBC interfaces. Using from Tools walks through the steps of integration with JDBC tools, using several popular database tools as examples. See Using JDBC for examples of using standard JDBC classes like DataSource, Connection, Statement, ResultSet, and others, to work with Anzo data. See the Anzo integration guides for information on connecting from other applications. See Getting Started for A-Z guides on authenticating and connecting to Anzo data. Codeless integration with popular BI, reporting, and ETL tools.Write SQL to retrieve and update Anzo data.Deploy a single JAR that does not rely on client-side libraries.The driver hides the complexity of accessing data and provides additional powerful security features, smart caching, batching, socket management, and more. Applications can then access Anzo as a traditional database. The driver wraps the complexity of accessing Anzo data in an easy-to-integrate, 100%-Java JDBC driver. The CData JDBC Driver for Anzo offers the most natural way to connect to Anzo data from Java-based applications and developer technologies.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |