Hi people,
First, thanks a lot for your support.
I'm new to OrientDB. In order to populate our DB, I need to to import there
some data from the SQL-Server, and I meet a problem there.
I use the Community edition 2.1.11 bundled with ETL.
I've downloaded the Microsoft JDBC Driver 4.2 for SQL Server, unzipped it
to the default folder in Program Files (x86), as recommended in the
installation instructions; I've also put the sqljdbc4.jar into the
%orientdb_home%/lib folder, and put the sqljdbc_auth.dll into the
windows/system32.
But when I try to run the json (based on Raj's one, thank you man:)), i get
an error: "failed to load the sqljdbc_auth.dll cause no sqljdbc_auth in
java.library.path". I've found how to add things to that path, but I need a
name of class (??, I'm totally unfamiliar with java administration) - and I
don't know it..
Any suggestions?
Regards,
Gregory
On Wednesday, November 19, 2014 at 7:28:19 PM UTC+2, Curtis Mosters wrote:
>
> Did you put the MSSQL driver in the Lib folder?. Because I needed one for
> MySQL.
>
> Am Mittwoch, 19. November 2014 17:46:22 UTC+1 schrieb Raj:
>>
>>
>> Currently, I am using *orientdb-community-1.7.9 *and *MySQL *database.
>> On Wednesday, November 19, 2014 6:43:05 PM UTC+2, GoorMoon wrote:
>>>
>>> Are you using orientdb-etl 2.0-M3 version with oriendb-community-1.7.9
>>> version?
>>>
>>> On Wednesday, November 19, 2014 6:20:42 PM UTC+2, Raj wrote:
>>>>
>>>> I didn't know that earlier. Thank you ! I tried that and I get a
>>>> exception. I have also attached the images.
>>>>
>>>> On Wednesday, November 19, 2014 5:15:27 PM UTC+2, GoorMoon wrote:
>>>>>
>>>>> You need to run from cmd and not from studio.
>>>>> Save you config file with directory oetl.bat (exm. config.json)
>>>>> and run *oetl.bat config.json from* command prompt.
>>>>>
>>>>>
>>>>> On Wednesday, November 19, 2014 5:01:58 PM UTC+2, Raj wrote:
>>>>>>
>>>>>> Hi ! Thank you for your guidance. I tried with *orientdb-community-1.7.9
>>>>>> *edition (because this was meant for production) and this time using
>>>>>> *MySQL
>>>>>> database (*because your instructions are using mysql*)* and it
>>>>>> failed again. I have attached images of the folders, files etc., and
>>>>>> here
>>>>>> is my code:
>>>>>> {
>>>>>> "config": {
>>>>>> log : "debug"
>>>>>> },
>>>>>> "extractor" : {
>>>>>> "jdbc": { "driver": "com.mysql.jdbc.Driver",
>>>>>> "url": "jdbc:mysql://localhost/dbo",
>>>>>> "userName": "root",
>>>>>> "userPassword": "systems",
>>>>>> "query": "select * from garden" }
>>>>>> },
>>>>>>
>>>>>> "transformers" : [
>>>>>> { "vertex": { "class": "garden"} }
>>>>>> ],
>>>>>> "loader" : {
>>>>>> "orientdb": {
>>>>>> "dbURL":
>>>>>> "plocal:C:\Users\RajBharath\Documents\orientdb-community-1.7.9\databases\Saga",
>>>>>> dbUser: "root",
>>>>>> dbPassword: "root",
>>>>>> dbAutoDropIfExists: false,
>>>>>> dbAutoCreate: true,
>>>>>> tx: false,
>>>>>> wal: false,
>>>>>> batchCommit: 1000,
>>>>>> dbType: "graph",
>>>>>> indexes: [{class:"garden", fields:["id:string"],
>>>>>> type:"UNIQUE_HASH_INDEX" }]
>>>>>> }
>>>>>> }
>>>>>> }
>>>>>>
>>>>>>
>>>>>> On Wednesday, November 19, 2014 9:58:29 AM UTC+2, Curtis Mosters
>>>>>> wrote:
>>>>>>>
>>>>>>> Hey, well I don't have MS Server installed, so I cannot test.
>>>>>>>
>>>>>>> But as I see you are using the old way of ETL. Could you test:
>>>>>>>
>>>>>>> {
>>>>>>> "config": {
>>>>>>> log : "debug"
>>>>>>> },
>>>>>>> "extractor" : {
>>>>>>> "jdbc": { "driver": "com.mysql.jdbc.Driver",
>>>>>>> "url": "jdbc:mysql://localhost/test",
>>>>>>> "userName": "root",
>>>>>>> "userPassword": "",
>>>>>>> "query": "select * from Author" }
>>>>>>> },
>>>>>>> "transformers" : [
>>>>>>> { "vertex": { "class": "Author"} }
>>>>>>> ],
>>>>>>> "loader" : {
>>>>>>> "orientdb": {
>>>>>>> "dbURL":
>>>>>>> "plocal:D:\path\orientdb-community-2.0-M1\databases\Test6",
>>>>>>> dbUser: "root",
>>>>>>> dbPassword: "root",
>>>>>>> dbAutoDropIfExists: false,
>>>>>>> dbAutoCreate: true,
>>>>>>> tx: false,
>>>>>>> wal: false,
>>>>>>> batchCommit: 1000,
>>>>>>> dbType: "graph",
>>>>>>> indexes: [{class:"Author", fields:["id:string"], type:
>>>>>>> "UNIQUE_HASH_INDEX" }]
>>>>>>> }
>>>>>>> }
>>>>>>> }
>>>>>>>
>>>>>>> This one worked for me in 2.0-M1. So give it a try and edit things
>>>>>>> that are needed for MS Server. Let me know.
>>>>>>>
>>>>>>> Am Dienstag, 18. November 2014 22:40:39 UTC+1 schrieb Raj:
>>>>>>>>
>>>>>>>> I am using Windows 8.1. Also, I want to import from SQL Server 2012
>>>>>>>> hence I can't use Linux.
>>>>>>>>
>>>>>>>> On Tuesday, November 18, 2014 7:50:55 PM UTC+2, GoorMoon wrote:
>>>>>>>>>
>>>>>>>>> You need run this with tool like this on linux
>>>>>>>>>
>>>>>>>>> Usage
>>>>>>>>>
>>>>>>>>> $ cd $ORIENTDB_HOME/bin
>>>>>>>>> $ ./oetl.sh config-dbpedia.json
>>>>>>>>>
>>>>>>>>> On Tuesday, November 18, 2014 3:02:55 PM UTC+2, Raj wrote:
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>> On Tuesday, November 18, 2014 12:48:35 PM UTC+2, Raj wrote:
>>>>>>>>>>>
>>>>>>>>>>> Is there any mistake in JSON ?
>>>>>>>>>>>
>>>>>>>>>>> I use :OrientDB 2.0-M2 Community Edition
>>>>>>>>>>>
>>>>>>>>>>> On Monday, November 17, 2014 10:56:13 PM UTC+2, Raj wrote:
>>>>>>>>>>>>
>>>>>>>>>>>> Thanks ! I did all the steps, but after adding the jar file and
>>>>>>>>>>>> executing I still get this error:
>>>>>>>>>>>> com.orientechnologies.orient.core.command.OCommandExecutorNotFoundException:
>>>>>>>>>>>>
>>>>>>>>>>>> Cannot find a command executor for the command request: sql.{
>>>>>>>>>>>> "config": {
>>>>>>>>>>>> "verbose": true }, "extractor" : { "jdbc": { "driver":
>>>>>>>>>>>> "com.microsoft.sqlserver.jdbc.SQLServerDriver", "url":
>>>>>>>>>>>> "jdbc:sqlserver:
>>>>>>>>>>>>
>>>>>>>>>>>> On Monday, November 17, 2014 9:29:59 PM UTC+2, GoorMoon wrote:
>>>>>>>>>>>>>
>>>>>>>>>>>>>
>>>>>>>>>>>>> - Clone the repository on your computer, by executing:
>>>>>>>>>>>>> - git clone
>>>>>>>>>>>>> https://github.com/orientechnologies/orientdb-etl.git
>>>>>>>>>>>>> - Compile the module, by executing:
>>>>>>>>>>>>> - mvn clean install
>>>>>>>>>>>>>
>>>>>>>>>>>>> You need to compile this using maven.
>>>>>>>>>>>>> On windows follow this steps
>>>>>>>>>>>>> http://www.mkyong.com/maven/how-to-install-maven-in-windows
>>>>>>>>>>>>> Then in target directory you be able to find orientdb-etl-2.0-
>>>>>>>>>>>>> SNAPSHOT.jar
>>>>>>>>>>>>>
>>>>>>>>>>>>>
>>>>>>>>>>>>> On Monday, November 17, 2014 9:15:44 PM UTC+2, Raj wrote:
>>>>>>>>>>>>>>
>>>>>>>>>>>>>> Yes, I am trying to do that but unable to find the .jar file
>>>>>>>>>>>>>> and hence, unable to execute this step:
>>>>>>>>>>>>>>
>>>>>>>>>>>>>> - Copy target/orientdb-etl-2.0-SNAPSHOT.jar to
>>>>>>>>>>>>>> $ORIENTDB_HOME/lib
>>>>>>>>>>>>>>
>>>>>>>>>>>>>>
>>>>>>>>>>>>>> On Monday, November 17, 2014 7:50:20 PM UTC+2, Raj wrote:
>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>> I am new to OrientDB and JSON. I am trying to follow the
>>>>>>>>>>>>>>> steps in:
>>>>>>>>>>>>>>> http://www.orientechnologies.com/docs/last/orientdb-etl.wiki/Import-from-DBMS.html
>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>> I am not able to find the file:
>>>>>>>>>>>>>>> target/orientdb-etl-2.0-SNAPSHOT.jar
>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>> I executed the following JSON on OrientDB Studio:
>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>> {
>>>>>>>>>>>>>>> "config": {
>>>>>>>>>>>>>>> "verbose": true
>>>>>>>>>>>>>>> },
>>>>>>>>>>>>>>> "extractor" : {
>>>>>>>>>>>>>>> "jdbc": { "driver":
>>>>>>>>>>>>>>> "com.microsoft.sqlserver.jdbc.SQLServerDriver",
>>>>>>>>>>>>>>> "url":
>>>>>>>>>>>>>>> "jdbc:sqlserver://localhost;databaseName=GardenDB",
>>>>>>>>>>>>>>> "userName": "fa",
>>>>>>>>>>>>>>> "userPassword": "sunflower",
>>>>>>>>>>>>>>> "query": "select * from Garden" }
>>>>>>>>>>>>>>> },
>>>>>>>>>>>>>>> "transformers" : [
>>>>>>>>>>>>>>> { "vertex": { "class": "Garden"} }
>>>>>>>>>>>>>>> ],
>>>>>>>>>>>>>>> "loader" : {
>>>>>>>>>>>>>>> "orientdb": {
>>>>>>>>>>>>>>> "dbURL":
>>>>>>>>>>>>>>> "plocal:C:\orientdb-community-2.0-M2\databases\BigGarden",
>>>>>>>>>>>>>>> "dbAutoCreate": true
>>>>>>>>>>>>>>> }
>>>>>>>>>>>>>>> }
>>>>>>>>>>>>>>> }
>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>> I get this result:
>>>>>>>>>>>>>>> "com.orientechnologies.orient.core.command.OCommandExecutorNotFoundException:
>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>> Cannot find a command executor for the command request: sql.{
>>>>>>>>>>>>>>> "config": {
>>>>>>>>>>>>>>> "verbose": true }, "extractor" : { "jdbc": { "driver":
>>>>>>>>>>>>>>> "com.microsoft.sqlserver.jdbc.SQLServerDriver", "url":
>>>>>>>>>>>>>>> "jdbc:sqlserver:
>>>>>>>>>>>>>>> "
>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>> I request you to let me know the steps to export data from
>>>>>>>>>>>>>>> MS-SQL Server 2012 to OrientDB.
>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>
--
---
You received this message because you are subscribed to the Google Groups
"OrientDB" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
