![]() ![]() ![]() This tutorial covers the basics of setting up the connection, executing queries, and handling results. Request a demo of the CData Connect and start working with Cassandra just like a MySQL database today. Learn how to connect to a MySQL database from Java using various techniques, such as JDBC, Hibernate, and Spring Data JPA. With access to live Cassandra data from MySQL Workbench, you can easily query and update Cassandra, just like you would a MySQL database. Write a SQL query to retrieve Cassandra data, like SELECT * FROM cassandradb.Customer.Open the connection you just created (CData Connect).Click Test Connection to ensure the connection is configured properly and click OK.Click Store in Vault to set and store the password.Set the Hostname, Port, and Username parameters to connect to the SQL Gateway.In MySQL Workbench, click to add a new MySQL connection.The steps below outline connecting to the virtual Cassandra database in Connect from MySQL Workbench and issuing basic queries to work with live Cassandra data. With the virtual database created, you are ready to connect to Cassandra from MySQL Workbench. Click Privileges -> Add and add the new user (or an existing user) with the appropriate permissions.Additionally, to use internal authentication set the User and Password connection properties. Set the Server, Port, and Database connection properties to connect to Cassandra. Select "Cassandra" from Available Data Sources.Įnter the necessary authentication properties to connect to Cassandra.Login to Connect and click Connections.This article shows how to create a virtual database for Cassandra in Connect and work with live Cassandra data in MySQL Workbench.Ĭreate a Virtual MySQL Database for Cassandra DataĬData Connect uses a straightforward, point-and-click interface to connect to data sources and generate APIs. When paired with CData Connect (on-premise or Connect Server), you get live access to Cassandra data as if it were a MySQL database. MySQL Workbench allows users to administer MySQL environments and gain better visibility into databases. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |