http://forums.visokio.com/discussions/tagged/database_table_outputs/feed.rss Mon, 30 Oct 17 15:01:43 -0400 Tagged with database_table_outputs - Visokio Forums en-CA http://forums.visokio.com/discussion/3039/sources-connecting-to-microsoft-sql-server-2014s Mon, 23 Nov 2015 05:37:19 -0500 Mark_berger 3039@/discussions
I am desperately trying to connect to a Microsoft SQL version version 2014, but without any luck.
Has anyone succeeded doing this? What am I doing wrong?

It is not a firewall issue and the naming is correct too.

Looking forward for your replies. A huge "Thanks" in advance.]]> http://forums.visokio.com/discussion/2590/idea-sql-database-output-merge-new-changed-recordss Wed, 11 Jun 2014 06:59:51 -0400 SimonWiggins 2590@/discussions
I'm looking to update a SQL table daily with new data. Obviously an Append would do this job if the data to be added was always only new data.

The problem comes when some values from previous days have been corrected or updated and these also need pushing to the same database.

I have a solution that compares the last few days data (from the database) with the same number of days from the source and if it's new it Appends, if it's corrected it Updates. The solution is adequate if a bit slow for large data sets as it appears to publish line by line and requires the last few days from the database to be pulled back into the Omniscope process.

My idea/suggestion would be to include another option in the Database output block that uses the Merge command.
If anyone else has solutions for this that work better please let me know. Not sure if this is possible or even has enough people wanting it?

Thanks,]]> http://forums.visokio.com/discussion/2803/export-changing-character-set-in-database-outputs Fri, 02 Jan 2015 05:35:32 -0500 Alexander 2803@/discussions
First of all, the best wishes for 2015!

We use a DataManager workflow that publishes data into a database table. Based on the situation, we adjust the publication setting (Insert, Update, etc). Special tokens like ü, ë and é are being saved incorrectly in the database.

Therefore we would like to manually adjust the charset that Omniscope uses to publish database tables.

Can you advise how this can be configured?]]> http://forums.visokio.com/discussion/2742/import-custom-stopwords-into-mysql-running-in-amazon-rdss Mon, 13 Oct 2014 05:36:07 -0400 sathish 2742@/discussions
Could anyone help us in adding the custom stopwords (For example: 'and', 'so' ) to the stopwords list for MYSQL running in Amazon RDS Server.]]> http://forums.visokio.com/discussion/2657/exports-database-tables-syntax-errors Thu, 24 Jul 2014 06:22:34 -0400 CNourseHoK 2657@/discussions
I have been trying to migrate tables from one database to another and it's been going fine until receiving the following error. It states that there is a syntax error near "(" at position 100.

What does position 100 refer to? Also, I presume that a syntax error relates to the underlying command in the output block?

Please see the attached screenshot and let me know if you might know the cause of the problem.

Best,
Chris

]]> http://forums.visokio.com/discussion/2246/new-sources-ingresvectorwise-support-2.9- Wed, 17 Jul 2013 05:29:01 -0400 chris 2246@/discussions
In Omniscope 2.9 we have now added support for reading/writing to Actian Ingres and Vectorwise databases. For more information on these databases see:

http://www.actian.com/products/ingres
http://www.actian.com/products/vectorwise
]]> http://forums.visokio.com/discussion/1843/outputs-database-tables-field-lengthss Thu, 18 Oct 2012 05:56:40 -0400 aknotts 1843@/discussions http://forums.visokio.com/discussion/1894/mergejoin-sequencing-multiple-merge-operationss Mon, 12 Nov 2012 04:27:18 -0500 kattasureshkumar 1894@/discussions
Suppose we have employee , department & salary data. Initially we had prepared individual IOK Files and were running in the desired sequence Department --> Employee --> Salary . But now, we want to combine them to a single IOK File. Are we be able to control the sequencing in the Omniscope DataManager?

Also attached the sample IOK File into which we are importing Emp, Dept & Salary Data and at the last all the info from tables is joined and Excel output is generated from the custom SQL. Can we control sequencing here, so that the custom SQL runs last, after all the data from the flat files has been uploaded to the Oracle tables?

Thanks, Suresh.]]> http://forums.visokio.com/discussion/1889/outputs-addinsert-rows-to-database-tabless Fri, 09 Nov 2012 11:21:08 -0500 earheart 1889@/discussions
Am I missing something?]]> http://forums.visokio.com/discussion/1865/performance-etl-is-bulk-insert-possibles Thu, 25 Oct 2012 10:56:13 -0400 kattasureshkumar 1865@/discussions
While importing and validating the records we had not faced any performance issues, but while inserting these records to Oracle Database tables, we are facing performance issues. It is taking around 8 Hrs to insert 2 Million records on 64 Bit, 4 GB RAM system when we use the "DATABASE OUTPUT" block.

I suppose the tool is using manual/one by one insertion commands. Please let us know if we can do bulk inserts using this tool so that the performance when inserting large numbers of records can be improved.]]> http://forums.visokio.com/discussion/1818/datamanager-automatically-importexport-database-tabless Tue, 09 Oct 2012 06:39:56 -0400 Alfonso 1818@/discussions
I defined a data flow like this: Open database -> organize fields -> validate data -> publish data using a database table output only. My data flow does not include a load into the blue ouput block representing the in-memory DataExplorer output for visualisation/presentation/reporting. Could we have the ability to launch this type of ETL data flow in batch mode (silent or no prompts doesn't allow the publish process run automatically)? Please if you have any ideas, let me know. - Alfonso
]]> http://forums.visokio.com/discussion/1709/output-database-tables-datetime-values-2.8- Thu, 16 Aug 2012 07:16:03 -0400 sunicha_sherriff 1709@/discussions
But the result is Omniscope change my content that you can see in picture "Result Content" and see at column Platts Created. It changed from "Oct 1, 2010 5:42:26 PM" to "Oct 1, 2010 12.00.00 AM". Omniscope 2.8 build 258(Alpha) *64

Best Regards - Palm]]> http://forums.visokio.com/discussion/904/datamanager-api-feeds-and-sql-servers Tue, 02 Aug 2011 23:12:49 -0400 shamong 904@/discussions
Meaning to say, the data is extracted from the feeds and linked to the SQL Server stored locally for some minor processing to be done straight from the server?

Thanks!]]>