Invantive Query Tool for SQL with Exact Online
Invantive Query Tool for SQL with Exact Online. http://www.invantive.com/products/invantives-free-query-tool-exact-online-edition
This video teaches you how to use the Invantive Query Tool for SQL with Exact Online. Invantive's free SQL Query Tool for Exact Online provides you with real-time Business Intelligence across your entire enterprise. It provides access to your crucial company information stored in the Exact Online cloud. No programming, no coding, no Excel downloads; just use the SQL knowledge you already have. This enables you to organize your business data fast for correct decision making. You are be able to extract, analyze and report business data such as sales leads, project execution, general ledger transactions and accounts payables.
This is a free and maintained product which is available on our website in the downloads section. When the application starts it will first check for newer version of the software from the website.If it does find a newer version, the program will ask you if you want to upgrade or stay with the current version of the software. The first step to connect to Exact Online in the cloud, with SQL, is to choose the right connection. In this case the connection has the name "Invantive Webservice - Exact Online". The connection you'll use will also contain the words "Exact Online".The name you will use contain exact online but it may have an extension like "cloud test".
In the user name field you enter the user name you use to connect to Exact Online on the Internet. Then you log in to Exact Online with the query tool using the green log in button. OK, now the Invantive Query Tool opens. Here you can see the window is divided into two main parts. In the top part of the window you enter the SQL statements that you wish to execute. You can execute them on Exact Online, but you also can run queries on: Microsoft SQL Server, Oracle MySQL, Teradata, Oracle RDBMS or any ODBC source.
Ok, we are going to start simple. Let's write a query for Exact Online. As you can see, as you type, the software provides you with a suggestion for words to use for your SQL queries. These automatic suggestions work for SQL keywords, and they also work for tables and views in Exact Online. To execute the query press CTRL plus Enter or click the "Execute" button here in the top left corner. The results will now be fetched using the Exact Online interface protocols. The results are presented in a grid format. You can customize this grid yourself in the format that you like to use for your reports. And this layout can be saved for future use by clicking on Display - Layout, here you find a save button. Each time you execute the same query again, the same layout will be applied to your query.
This video teaches you how to use the Invantive Query Tool for SQL with Exact Online. Invantive's free SQL Query Tool for Exact Online provides you with real-time Business Intelligence across your entire enterprise. It provides access to your crucial company information stored in the Exact Online cloud. No programming, no coding, no Excel downloads; just use the SQL knowledge you already have. This enables you to organize your business data fast for correct decision making. You are be able to extract, analyze and report business data such as sales leads, project execution, general ledger transactions and accounts payables.
This is a free and maintained product which is available on our website in the downloads section. When the application starts it will first check for newer version of the software from the website.If it does find a newer version, the program will ask you if you want to upgrade or stay with the current version of the software. The first step to connect to Exact Online in the cloud, with SQL, is to choose the right connection. In this case the connection has the name "Invantive Webservice - Exact Online". The connection you'll use will also contain the words "Exact Online".The name you will use contain exact online but it may have an extension like "cloud test".
In the user name field you enter the user name you use to connect to Exact Online on the Internet. Then you log in to Exact Online with the query tool using the green log in button. OK, now the Invantive Query Tool opens. Here you can see the window is divided into two main parts. In the top part of the window you enter the SQL statements that you wish to execute. You can execute them on Exact Online, but you also can run queries on: Microsoft SQL Server, Oracle MySQL, Teradata, Oracle RDBMS or any ODBC source.
Ok, we are going to start simple. Let's write a query for Exact Online. As you can see, as you type, the software provides you with a suggestion for words to use for your SQL queries. These automatic suggestions work for SQL keywords, and they also work for tables and views in Exact Online. To execute the query press CTRL plus Enter or click the "Execute" button here in the top left corner. The results will now be fetched using the Exact Online interface protocols. The results are presented in a grid format. You can customize this grid yourself in the format that you like to use for your reports. And this layout can be saved for future use by clicking on Display - Layout, here you find a save button. Each time you execute the same query again, the same layout will be applied to your query.
Category
📚
Learning