Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Mapping from remote DB2 database to a remote Neo4j database returns no results #60

Open
FillardMillmore opened this issue Nov 7, 2019 · 0 comments

Comments

@FillardMillmore
Copy link

FillardMillmore commented Nov 7, 2019

I am running the Neo4j Desktop v1.2.1 and Neo4j ETL Tool v1.4.2 on a Windows 10 machine. I have a remote instance of Neo4j running on a Linux machine (Neo4j v3.5.6) and I have a dB2 database running on an IBM i machine.

I am using a JDBC to connect to the dB2 database and 'Test Connection' results in success (though it does appear to register my username as the schema, even though I am specifying a default schema that is not my username) I am trying to use the ETL tool to map metadata and though the connection appears to be successful, the output (in the logs) is empty. I have attached a picture of my JDBC setup and the resulting logs (when I hit 'Start Mapping'). Any help or tips or questions for more information would be appreciated!

neo4j_github_dsn_example

COMMAND: java -cp "C:\Users\User\.Neo4jDesktop\graphApps\_global\neo4j-etl-ui/dist/neo4j-etl.jar;C:\Program Files\IBM\SDPShared\plugins\com.ibm.datatools.db2_2.2.201.v20151119_1817\driver\db2jcc_license_cisuz.jar;C:\Program Files\IBM\SDPShared\plugins\com.ibm.datatools.db2_2.2.201.v20151119_1817\driver\db2jcc4.jar" org.neo4j.etl.NeoIntegrationCli generate-metadata-mapping --rdbms:url "jdbc:db2://192.168.1.3:446/S1031056" --rdbms:password "password" --rdbms:user "user" --schema "LSCPRDLIB" --output-mapping-file "C:\Users\USER\AppData\Local\Temp/db2_S1031056_LSCPRDLIB_mapping.json"
- Skipping reading import options from file because file [] doesn't exist.
- Creating RDBMS to CSV mappings...
Available schema: #CGULIB
.....(*ABRIDGED FOR BREVITY)
Available schema: ZMARIADB
- Using database plugin for 
- Crawling schemas
- Retrieving all schemas
- Retrieving all catalogs
- Processed 597 rows for <retrieveAllSchemas>
- Including schema LSCPRDLIB
- Retrieved 1 schemas
- Including schema LSCPRDLIB
- Total time taken for <crawlSchemas> - 00:00:00.063 hours
- 98.4% - 00:00:00.062 - <retrieveSchemas>
-  1.6% - 00:00:00.001 - <sortAndFilterSchemas>

- Retrieving database information
- Not retrieving additional database information, since this was not requested
- Retrieving JDBC driver information
- Not retrieving additional JDBC driver information, since this was not requested
- Retrieving SchemaCrawler crawl information
- Total time taken for <crawlDatabaseInfo> - 00:00:00.011 hours
-  0.0% - 00:00:00.000 - <retrieveDatabaseInfo>
-  0.0% - 00:00:00.000 - <retrieveAdditionalDatabaseInfo>
-  0.0% - 00:00:00.000 - <retrieveJdbcDriverInfo>
-  0.0% - 00:00:00.000 - <retrieveAdditionalJdbcDriverInfo>
-100.0% - 00:00:00.011 - <retrieveCrawlHeaderInfo>

- Crawling column data types
- Retrieving system column data types
- Not retrieving user column data types, since this was not requested
- Total time taken for <crawlColumnDataTypes> - 00:00:00.024 hours
-100.0% - 00:00:00.024 - <retrieveSystemColumnDataTypes>
-  0.0% - 00:00:00.000 - <retrieveUserDefinedColumnDataTypes>

- Crawling tables
- Retrieving tables
- Retrieving tables for schema <LSCPRDLIB>
- Processed 3704 rows for <retrieveTables>
- Retrieved 0 tables
- Crawling routines
- Retrieved 0 routines
- Not retrieving synonyms, since this was not requested
- Not retrieving sequences, since this was not requested

OUTPUT:
[ ]
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant