0

MS SQL connector - multiple commands

zsery 5 місяців тому в Studio / Sources 0

Exists any possibility how to execute more command during one connection? I mean 2 stored procedures ....
Thanks

+1
Є відповідь

Connector SQL Server ERROR ExecuteXMLReader

Michael 6 місяців тому в Studio / Sources • оновлено Elmo 6 місяців тому 6

Hi, 


I have a problem with the stored procedure on the MSSQL server. I did it the same way as in the tutorial PDF, but with a different database. When I want to debug the flow, I only get the following error message: The command sent to ExecuteXmlReader is invalid. The command must return an XML result.


Thanks in advance.




database debug execution service source studio workflow
0
Є відповідь

SQL Bulk Insert

ahmad.zikri 2 роки тому в Studio / Sources • оновлено Gandalf 2 роки тому 5

I've been trying to use SQL Bulk Insert service however with Oracle i unable to choose table:

database
Відповідь
Gandalf 2 роки тому

Hi Ahmad

The bulk insert is for Microsoft SQL server.

0
Є відповідь

Oracle Database Source

ahmad.zikri 2 роки тому в Studio / Sources • оновлено Genie 2 роки тому 1

Hi. Why when I create Oracle database source the database choices are limited to HR, SCOTT, OE, PM, SH and IX

There should be user that i create as database. For example, there be include 'SPBO2' as if in normal oracle query it will be SELECT * FROM SPBO2.TABLENAME

Thank you

database
Відповідь
Genie 2 роки тому

Hi,


The databases are limited to the databases that the that you have logged in with has access to, using the following command


SELECT DISTINCT(OWNER) AS DATABASE_NAME FROM DBA_SEGMENTS WHERE OWNER IN (SELECT USERNAME FROM DBA_USERS WHERE DEFAULT_TABLESPACE NOT IN ('SYSTEM','SYSAUX'))


Thanks

0
Є відповідь

Connection to Oracle Database

FSulaiman 2 роки тому в Studio / Sources • оновлено Genie 2 роки тому 19

I want to connect to New Datasource Database in Oracle.

The info as below


IP address : 192.168.50.30

Operating platform : Windows Server 2012 R2 Standard

Database/OraClient installed : Oracle 11g R2 Client 64bit

user: orcluser

password: orclpassword

SID: orcl

port: 1521


How to setup the oracle connection?


Відповідь
Genie 2 роки тому

Hi,


The databases are limited to the databases that the that you have logged in with has access to, using the following command


SELECT DISTINCT(OWNER) AS DATABASE_NAME FROM DBA_SEGMENTS WHERE OWNER IN (SELECT USERNAME FROM DBA_USERS WHERE DEFAULT_TABLESPACE NOT IN ('SYSTEM','SYSAUX'))


Thanks

0
Є відповідь

VB DLLs and Objects

Justin Blaauw 3 роки тому в Studio / Sources • оновлено Gandalf 3 роки тому 2
I am fairly new to the Microsoft experience, but was wondering if the DLLs have to be C# or can they be VB to use in Warewolf? Can I create objects in the DLL and access them from Warewolf ?
source
0
Є відповідь

Warewolf support of DB servers

Анонім 4 роки тому в Studio / Sources • оновлено Gandalf 3 роки тому 4
Hey guys,
I just have a random question. Does Warewolf cater for non-SQL Server DB servers like MySQL and Oracle?
If it doesn’t can you please just explain why?

Thanks :)
Відповідь
Gandalf 4 роки тому
Hi Anonymous

Warewolf is designed to cater for any database. We haven't had the request from any clients (or any additions from the community on GITHUB) for anything other than MSSQL yet. The plan is to implement Oracle, MySQL etc. as soon as there is a demand.

Let us know if you need something prioritized.
+2
Виконано

Edit Database Source

Alex Hampel 6 років тому в Studio / Sources • оновлено Gandalf 6 років тому 0

Suggestion: Order databases alphabetically.



Відповідь
Gandalf 6 років тому

Consider it done.