Questions tagged [invantive-sql]

Invantive UniversalSQL (formerly: "Invantive SQL") is a SQL language and execution engine which retrieves and stores data in many traditional databases as well as cloud-based applications using a consistent SQL dialect, such as Exact Online, Freshdesk, Microsoft Dynamics, Stack Exchange, etc.

Invantive UniversalSQL (formerly: "Invantive SQL") is a SQL language and execution engine which retrieves and stores data in many traditional databases as well as cloud-based applications using a consistent SQL dialect, such as Exact Online, Freshdesk, Microsoft Dynamics, Stack Exchange, etc.

Invantive PSQL is a procedural extension on top of SQL included with Invantive UniversalSQL. Please use the tag for Invantive UniversalSQL for PSQL questions.

Questions should include relevant SQL statements to reproduce the problem, when possible on the reference database Dummy. Also include appropriate tag(s) for the databases and/or cloud-applications you are querying, like or .

For product use questions use Super User.


If you want to ask a question about an error you get when firing a SQL statement, copy this template into your question:

Problem statement:

[explain what you want to achieve]

Steps to reproduce:

  1. The first step

  2. The second step

     The SQL code you used (don't use images but code formatting)
    
    

Expected result: [show or explain the expected result, preferably in text]

Actual result: [show or explain the actual result, preferably in text. If you received an error, include the full error in the block below]

> [The error message]

14 questions
6
votes
3 answers

How to get the PictureURL from the Exact Online XML-feed to show the picture using Invantive Data Access Point?

When using Data Access Point to generate an XML feed, using the following query: select * from exactonlinerest..items the resulting XML has a…
3
votes
1 answer

Specify required freshness of data from Data Cache

I am using Invantive SQL for Exact Online to integrate BOARD with Exact Online. For caching, Invantive Data Cache is configured. By default the data remains fresh enough for the /*+ ods */ hint to be used for 7 days. I can switch the Data Cache…
2
votes
1 answer

Why doesn't 'ItemsRead' in Invantive Data Access Point work anymore?

I've had a working update-script the last few months, but since 3 days ago the updating doesn't work anymore. The error returns that it can't find the table ItemsRead, but it's in the alternatives. My query returns the following error. Invantive…
RH1985
  • 93
1
vote
1 answer

itgendch023: Backing database of Data Cache could not be opened

I've configured Invantive Data Cache on my connection to Exact Online Belgium. It connects fine. But when I run the following query (for example) as a first query: select * from me I get a: Backing database of Data Cache could not be opened. Er is…
1
vote
1 answer

Configure user to solve itgenexl029 on SQL query on Exact Online

When I run the following query using Invantive Data Hub on Exact Online (Netherlands): create or replace table spn@inmemorystorage as select /*+ ods(false) */ spn.item_code_attr , spn.warehouse_code_attr , spn.item_description , …
1
vote
1 answer

Run all VirusTotal scanners on file released from MSBuild through SQL

We build software deliverables as files on a build server. Once every few months, some of these files are rejected by some of the virus scanners available. I want to avoid post-shipment issues with the files. How can I use the VirusTotal provider…
1
vote
2 answers

How can I use all of my Exact Online divisions with Invantive Bridge and PowerBI?

I'm using the Invantive Bridge ADO.NET provider to get my Exact Online data into Microsoft PowerBI. This is the query I currently use: let Source = AdoDotNet.Query ( "Invantive" ,…
1
vote
1 answer

How to add a custom field to the resulting Exact online XML feed using a query with Invantive Data Access Point?

For a customer we are building a custom made XML feed, but they added a custom field (Soort ProductDescription) in their Exact Online administration. How to get that extra field into the XML feed using Data Access Point?
RH1985
  • 93
0
votes
1 answer

Include Excel formula in block generated from SQL

Running Invantive Control for Excel, I want to fill a block with data from Exact Online. However, one of the columns should be the multiplication of the rate listed in a settings Excel worksheet with the amount in another column. When both values…
0
votes
1 answer

Access list of available tables on Exact Online for instance sales orders

I would like to access the list of available tables on Exact Online in the Query Tool. I've found some samples on superuser.com and stackoverflow.com with specific queries such as on transactionlines, but seem unable to get a complete list and the…
0
votes
1 answer

Missing internal rate on Exact Online employment

When you have an employment in Exact Online, you can have an internal rate. The APIs also list it as the column InternalRate in ExactOnlineREST..EmploymentSalaries. But in the tab Employment of an Employee it is not visible. How can I enter a value…
0
votes
1 answer

For sales person (cost center) provision list of sales invoices paid

In Exact Online you can not easily determine what invoices have recently been paid and get a total on that to base our provision for the sales persons on. How can I get such a list?
0
votes
1 answer

Per article and assortment code in Exact Online the revenues per month

I want to determine per article and assortment code in Exact Online the total quantity of items shipped and the division currency amount. Exact Online only offers an overview per account. How can I retrieve this list with Invantive Control?
0
votes
1 answer

Retrieve list of shop order budgeted man hours and actual made hours

How can I retrieve a combination of the budgeted man hours on an Exact Online shop order with the actual hours made? I can retrieve them separately using a query on exactonlinerest..MfgTimeTransactions (actuals) and…