![]() Connects to 40+ data sources including Microsoft SQL Server, Oracle Database, IBM Db2, MySQL, PostgreSQL, MongoDB, SQLite, Cassandra, Snowflake, and generic ODBCĬome and Talk to us to see how we can help!.Application program runs on Microsoft Windows, Linux, and Apple macOS.Easy integration with version control systems for SQL and files.In-depth comparison of schema, data, and files, and synchronization of schema.Powerful data visualization and analytics with dashboards and reporting.Efficient SQL editor, SQL checker, visual query builder, and ER diagram modeler.Flexible administration of databases and management of data.Modern and intuitive graphical user interface (GUI).Advanced integrated development environment (IDE) client for data sources.Explore the Extensive Capabilities of Aqua Data Studio IDE Develop, manage, and administer databases access, manage, and visually analyze data and connect to a large range of relational, cloud, and NoSQL database platforms. It enables database developers, database administrators, and data and business analysts to handle their multi-platform databases and the data contained within them. Look no further as Aqua Data Studio is your answer to that question UNIVERSAL DATABASE IDE AND VISUAL ANALYTICSĪqua Data Studio is a universal integrated development environment (IDE) for databases and visual analytics. In the query pane, enter and then run a SQL Query.Have you ever wanted an IDE that spans over 40+ database platforms in one single UI?.To retrieve some data, right-click the new Server in the Servers pane.Save the Server to return to Acqua Data Studio.On 64-bit Windows, the default location for is :\Program Files\Easysoft Limited\Easysoft JDBC-ODBC Bridge. On 64-bit Windows, the default location for is :\Program Files (x86)\Easysoft Limited\Easysoft JDBC-ODBC Bridge. Use the Browse button to browse for EJOB.jar.ĮJOB.jar is installed in the following location on the machine where you installed the Easysoft JDBC-ODBC Bridge:.Jdbc:easysoft://localhost/ data_source:logonuser= windows_user:logonpassword= password This field is only required of the target database requires it. In the left pane, choose Generic - JDBC.The Register Server dialog box is displayed. In Aqua Data Studio, choose Server > Register Server.Install and license the Easysoft JDBC-ODBC Bridge on the machine where the Aqua Data Studio is installed.įor installation instructions, see the Easysoft JDBC-ODBC Bridge documentation.Download the Easysoft JDBC-ODBC Bridge.If in doubt, in the Windows Run dialog box, type: The 32-bit version of ODBC Data Source Administrator should be clearly labelled. On some version of Windows, you need to search for ODBC in the taskbar search box. On some versions of Windows, this is located in Control Panel > Administrative Tools. To do this, use the 32-bit version of ODBC Data Source Administrator on your Aqua Data Studio machine. Configure a System ODBC data source for the database that you want to connect to in Aqua Data Studio.The process for using the Easysoft JDBC-ODBC Bridge with Aqua Data Studio is as follows: Note that the Easysoft JDBC-ODBC Bridge only supports 32-bit ODBC drivers. It is fully supported by Easysoft and is currently being deployed in production environments throughout the world. The Easysoft JDBC-ODBC Bridge has a Java component and a 32-bit native component. For example, the NVARCHAR column value, Production.Product, is returned as (null), when the SQL Server AdventureWorks database is accessed by using the JDBC-ODBC Bridge.Īs an alternative, if you need to connect Aqua Data Studio to an ODBC driver, you can also use the Easysoft JDBC-ODBC Bridge instead. Instead of the expected value for a Unicode column, "(null)" is returned. There appears to be an issue with Unicode data retrieved via the JDBC-ODBC Bridge.The JDBC-ODBC Bridge is not recommended for production use.You need to download a 1.7 version of the Java Runtime Environment (JRE) from AquaFold to use the JDBC-ODBC Bridge with Aqua Data Studio. Aqua Data Studio currently ships with Java 1.8, which no longer contains the JDBC-ODBC Bridge.Please bear in mind the following when using the JDBC-ODBC Bridge that's included in the Java distribution with Aqua Data Studio: For example, if you wanted to analyse data in Aqua Data Studio, you could connect to in the following way:Īqua Data Studio > JDBC-ODBC Bridge > ODBC Driver > For example, Aqua Data Studio can work with data stored in Amazon Redshift and ships with a dedicated connector for this data store.Īqua Data Studio can also use the JDBC-ODBC Bridge that's included in the Java distribution as a generic connector for data stores for which there is an ODBC driver. Aqua Data Studio can analyse data stored in a number of back ends and includes a number of dedicated connectors for this purpose.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |