Invantive Data Hub is a console application which enables data changes, reporting and transport for traditional databases as well as cloud-based applications, using native SQL or Invantive SQL. Include SQL and possible local statements to reproduce a problem, when possible on the reference database Dummy. Also include appropriate tag(s) for the platform you are querying, like exact-online or freshdesk. For product use questions use Super User.
Questions tagged [invantive-data-hub]
12 questions
3
votes
1 answer
Invantive Data Hub query on Exact Online returns too many rows
when I use Invantive Data Hub to dowload data from multiple Exact Online companies , I get duplicate rows when I expect one row per company.
I use the following query:
select gla.code
, gla.description
, gla.division
, …
Mart
- 31
- 4
2
votes
1 answer
'Use select' notation to specify multiple partitions of Exact Online data container
I'd like to select an active partition in the Data Hub. Normally I would use the following statement:
INVANTIVE> use 1552839
2>
Exclamation itgendhb077: Error in Invantive Data Hub.
Database '1552839' does not exist. Make sure that the name is…
RS Finance
- 224
- 1
- 9
2
votes
1 answer
Determine list of selected partitions on Exact Online
When I set the list of active partitions in Data Hub using:
select code
from systemdivisions
where city='Rotterdam'
to all customers in Rotterdam, the next queries will retrieve data across all customers.
In Invantive Control I can see in the…
RS Finance
- 224
- 1
- 9
2
votes
1 answer
Upload contents of CSV as new maximum stock position in Exact Online
I want to upload the contents of a CSV file as new values in Exact Online data set using for instance the following SQL statement:
update exactonlinerest..ItemWarehouses
set maximumstock=0
where id='06071a98-7c74-4c26-9dbe-1d422f533246'
and …
PaulPSmith
- 41
- 2
1
vote
1 answer
itgendch033: Backing databases require Invantive Data Replicator to restrict the number of columns to 1,000 for 'ExactOnlineXML.XML.SubscriptionLines'
When executing the batch script to replicate my data from Exact Online, I get the following error:
Error itgencun016: Exclamation itgendch033: Backing databases require Invantive Data Replicator to restrict the number of columns to 1,000 for…
KPI Solutions
- 47
- 3
1
vote
1 answer
itgenuty427 on connec to Exact Online: Please configure api-client-id in your connection string
After re-installing the server with Windows and Invantive Data Hub with MySQL drivers, I get the following error when I try to connect to Exact Online (nl):
Waarschuwing itgenuty427: Een verbinding met de database 'Exact Online\Exact Online (nl)'…
Richard
- 21
- 2
1
vote
1 answer
Sending mail via Office 365 smtp using Invantive SQL
I'm trying to send a e-mail using the Invantive Data Hub using the following query (password and username are redacted).
insert into smtp@Mail
( fromEmail
, toEmail
, subject
, body
, smtpHostAddress
, smtpUsername
, smtpPassword
)
VALUES
(…
RS Finance
- 224
- 1
- 9
1
vote
1 answer
itgencun017: After a fresh Invantive Data Hub install, my batch script isn't working anymore
My script wasn't executing correctly, so I took a look at the log file that's also created by the batch script.
It shows the following error:
2017-09-05 07:34:24.324 Error itgencun016: Waarschuwing itgenuty427: Een verbinding met de database 'Oracle…
Richard
- 21
- 2
0
votes
1 answer
Missing encrypted Exact Online password with device-specific key warning itgendhb079
Customer is running Invantive Data Hub and has recently upgraded. The batch file used to include the following:
/password:PASSWORD
But the use of unencrypted seems no longer supported; I must provide an encrypted password instead. Invantive Data…
Guido Leenders
- 4,232
- 1
- 23
- 43
0
votes
1 answer
Change chosen SQL Server database in distributed database with Invantive Data Hub
We run a daily job to load Exact Online into a SQL Server database for reporting purposes with Sumatra.
We now want to redirect the SQL insert statement to another database on the same SQL Server.
Connections are:
…
0
votes
1 answer
Data Replicator connection string for use with Data Hub
I am trying to set up Invantive Data Hub with Replicator. The default discovery creates entries for Exact Online and others, but there is no entry in settings.xml which shows me how to configure data cache.
This one exists for example:
Jurriaan Buitenweg
- 422
- 2
- 12
0
votes
1 answer
Missing content of field CreatorFullName and ModifierFullName in GeneralJournalEntryLines
The business object GeneralJournalEntryLines contains the GL transaction lines of Exact Online. For performance tuning reasons, we are changing our scripts that copy data from Exact Online to our on-premise database to only include changes where…
Guido Leenders
- 4,232
- 1
- 23
- 43