In light of recent difficulties I've had mapping data directly from a Db2 database hosted on IBM i, I've decided to try importing data from Db2 to a Microsoft SQL Server. I've got two tables I've created (CUSTPRMP and CUSTEXTP) along with various other default/system tables that were included.
I'm running the SQL Server (Express) on a Windows 10 machine - I'm also running the Neo4j Desktop and ETL tool from the same Windows 10 machine. The Neo4j machine that I plan to import to is running on a Centos7 Virtual Machine (though, I don't think that's particularly relevant yet because I can't seem to get past the mapping step). Below, you can see what my Connection properties look like:
Connecting is successful and the mapping portion appears to be successful as it outputs all the data I'd expect (unlike when mapping from Db2, which produces a completely empty result set) but after the mapping step reports successful completion, the 'Next' button remains grayed out and 'unclickable' (or disabled). Below you'll find the result set (with some personal info edited out and slightly abridged to meet character limit of text body):
COMMAND: java -cp "C:\Users\USER\.Neo4jDesktop\graphApps\_global\neo4j-etl-ui-1-4-2-release/dist/neo4j-etl.jar;C:\Users\USER\Downloads\Microsoft JDBC Driver 7.4 for SQL Server\sqljdbc_7.4\enu\mssql-jdbc-7.4.1.jre8.jar" org.neo4j.etl.NeoIntegrationCli generate-metadata-mapping --rdbms:url "jdbc:sqlserver://localhost:1433;databaseName=master" --rdbms:password "password" --rdbms:user "sqladmin" --schema "master.dbo" --output-mapping-file "C:\Users\USER~1\AppData\Local\Temp/mssql_master_master.dbo_mapping.json"
- Skipping reading import options from file because file [] doesn't exist.
- Creating RDBMS to CSV mappings...
- Using database plugin for
- Crawling schemas
- Retrieving all schemas
- Retrieving all catalogs
- Processed 13 rows for <retrieveAllSchemas>
- Including schema master.dbo
- Retrieved 1 schemas
- Including schema master.dbo
- Total time taken for <crawlSchemas> - 00:00:00.051 hours
- 98.0% - 00:00:00.050 - <retrieveSchemas>
- 2.0% - 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.013 hours
- 7.7% - 00:00:00.001 - <retrieveDatabaseInfo>
- 7.7% - 00:00:00.001 - <retrieveAdditionalDatabaseInfo>
- 7.7% - 00:00:00.001 - <retrieveJdbcDriverInfo>
- 7.7% - 00:00:00.001 - <retrieveAdditionalJdbcDriverInfo>
- 69.2% - 00:00:00.009 - <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.040 hours
-100.0% - 00:00:00.040 - <retrieveSystemColumnDataTypes>
- 0.0% - 00:00:00.000 - <retrieveUserDefinedColumnDataTypes>
- Crawling tables
- Retrieving tables
- Retrieving tables for schema <master.dbo>
- Processed 11 rows for <retrieveTables>
- Retrieved 11 tables
- Retrieving table columns
- Retrieving foreign keys
- Including schema master.dbo
- Including schema master.dbo
- Including schema master.dbo
- Including schema master.dbo
- Including schema master.dbo
- Including schema master.dbo
- Including schema master.dbo
- Including schema master.dbo
- Including schema master.dbo
- Including schema master.dbo
- Including schema master.dbo
- Retrieving primary keys and indexes
- Retrieving indexes
- Retrieving primary keys
- Total time taken for <crawlTables> - 00:00:01.209 hours
- 14.0% - 00:00:00.169 - <retrieveTables>
- 45.7% - 00:00:00.552 - <retrieveColumns>
- 18.2% - 00:00:00.220 - <retrieveForeignKeys>
- 1.2% - 00:00:00.014 - <filterAndSortTables>
- 21.0% - 00:00:00.254 - <retrieveIndexes>
- 0.0% - 00:00:00.000 - <retrieveTableConstraintInformation>
- 0.0% - 00:00:00.000 - <isRetrieveTableConstraintDefinitions>
- 0.0% - 00:00:00.000 - <retrieveTriggerInformation>
- 0.0% - 00:00:00.000 - <retrieveViewInformation>
- 0.0% - 00:00:00.000 - <retrieveTableDefinitions>
- 0.0% - 00:00:00.000 - <retrieveIndexInformation>
- 0.0% - 00:00:00.000 - <retrieveAdditionalTableAttributes>
- 0.0% - 00:00:00.000 - <retrieveTablePrivileges>
- 0.0% - 00:00:00.000 - <retrieveAdditionalColumnAttributes>
- 0.0% - 00:00:00.000 - <retrieveTableColumnPrivileges>
- Crawling routines
- Retrieved 0 routines
- Not retrieving synonyms, since this was not requested
- Not retrieving sequences, since this was not requested
OUTPUT:
[ {
"name" : "NODE_master.dbo.MSreplicationoptions_19db7c8d-7f67-43ce-bb4c-e2fea742390e",
"schema" : "master.dbo",
"graph-object-type" : "Node",
"sql" : "SELECT \"master\".\"dbo\".\"MSreplication_options\".\"install_failures\" AS \"install_failures\", \"master\".\"dbo\".\"MSreplication_options\".\"revision\" AS \"revision\", \"master\".\"dbo\".\"MSreplication_options\".\"optname\" AS \"optname\", \"master\".\"dbo\".\"MSreplication_options\".\"minor_version\" AS \"minor_version\", \"master\".\"dbo\".\"MSreplication_options\".\"major_version\" AS \"major_version\", \"master\".\"dbo\".\"MSreplication_options\".\"value\" AS \"value\", 'MsreplicationOption' AS \"_NODE_LABEL_\" FROM \"master\".\"dbo\".\"MSreplication_options\"",
"mappings" : [ {
"column" : {
"type" : "SimpleColumn",
"role" : "PrimaryKey",
"table" : "MSreplication_options",
"schema" : "master.dbo",
"name" : "_ROW_INDEX_",
"alias" : "_ROW_INDEX_",
"sql-data-type" : "INTEGER",
"column-value-selection-strategy" : "SelectRowIndex"
},
"field" : {
"type" : "Id",
"name" : "",
"id-space" : "master.dbo.msreplication_options"
}
}, {
............[abridged]...........
}
} ]
}, {
"name" : "NODE_master.dbo.CUSTEXTP_49456c9e-c212-41a7-9dfd-4045d6b09a9f",
"schema" : "master.dbo",
"graph-object-type" : "Node",
"sql" : "SELECT \"master\".\"dbo\".\"CUSTEXTP\".\"ADDRESS\" AS \"ADDRESS\", 'Custextp' AS \"_NODE_LABEL_\" FROM \"master\".\"dbo\".\"CUSTEXTP\"",
"mappings" : [ {
"column" : {
"type" : "SimpleColumn",
"role" : "PrimaryKey",
"table" : "CUSTEXTP",
"schema" : "master.dbo",
"name" : "_ROW_INDEX_",
"alias" : "_ROW_INDEX_",
"sql-data-type" : "INTEGER",
"column-value-selection-strategy" : "SelectRowIndex"
},
"field" : {
"type" : "Id",
"name" : "",
"id-space" : "master.dbo.custextp"
}
}, {
"column" : {
"type" : "SimpleColumn",
"role" : "Data",
"table" : "CUSTEXTP",
"schema" : "master.dbo",
"name" : "ADDRESS",
"alias" : "ADDRESS",
"sql-data-type" : "VARCHAR",
"column-value-selection-strategy" : "SelectColumnValue"
},
"field" : {
"type" : "Data",
"name" : "ADDRESS",
"neo4j-data-type" : "String",
"is-array" : false
}
}, {
"column" : {
"type" : "SimpleColumn",
"role" : "Literal",
"table" : "CUSTEXTP",
"schema" : "master.dbo",
"name" : "Custextp",
"alias" : "_NODE_LABEL_",
"sql-data-type" : "VARCHAR",
"column-value-selection-strategy" : "SelectColumnValue"
},
"field" : {
"type" : "Label"
}
} ]
}, {
"name" : "NODE_master.dbo.CUSTPRMP_949eb880-a5ad-4135-9482-999d013a19cc",
"schema" : "master.dbo",
"graph-object-type" : "Node",
"sql" : "SELECT \"master\".\"dbo\".\"CUSTPRMP\".\"CUSTNUM\" AS \"CUSTNUM\", \"master\".\"dbo\".\"CUSTPRMP\".\"CUSTNUM\" AS \"CUSTNUM\", \"master\".\"dbo\".\"CUSTPRMP\".\"NAME\" AS \"NAME\", 'Custprmp' AS \"_NODE_LABEL_\" FROM \"master\".\"dbo\".\"CUSTPRMP\"",
"mappings" : [ {
"column" : {
"type" : "CompositeColumn",
"table" : "CUSTPRMP",
"schema" : "master.dbo",
"role" : "PrimaryKey",
"columns" : [ {
"type" : "SimpleColumn",
"role" : "Data",
"table" : "CUSTPRMP",
"schema" : "master.dbo",
"name" : "CUSTNUM",
"alias" : "CUSTNUM",
"sql-data-type" : "DECIMAL",
"column-value-selection-strategy" : "SelectColumnValue"
} ]
},
"field" : {
"type" : "Id",
"name" : "",
"id-space" : "master.dbo.custprmp"
}
}, {
"column" : {
"type" : "SimpleColumn",
"role" : "Data",
"table" : "CUSTPRMP",
"schema" : "master.dbo",
"name" : "CUSTNUM",
"alias" : "CUSTNUM",
"sql-data-type" : "DECIMAL",
"column-value-selection-strategy" : "SelectColumnValue"
},
"field" : {
"type" : "Data",
"name" : "CUSTNUM",
"neo4j-data-type" : "Double",
"is-array" : false
}
}, {
"column" : {
"type" : "SimpleColumn",
"role" : "Data",
"table" : "CUSTPRMP",
"schema" : "master.dbo",
"name" : "NAME",
"alias" : "NAME",
"sql-data-type" : "VARCHAR",
"column-value-selection-strategy" : "SelectColumnValue"
},
"field" : {
"type" : "Data",
"name" : "NAME",
"neo4j-data-type" : "String",
"is-array" : false
}
}, {
"column" : {
"type" : "SimpleColumn",
"role" : "Literal",
"table" : "CUSTPRMP",
"schema" : "master.dbo",
"name" : "Custprmp",
"alias" : "_NODE_LABEL_",
"sql-data-type" : "VARCHAR",
"column-value-selection-strategy" : "SelectColumnValue"
},
"field" : {
"type" : "Label"
}
} ]
},
[........abridged......]
"column" : {
"type" : "SimpleColumn",
"role" : "Data",
"table" : "spt_fallback_db",
"schema" : "master.dbo",
"name" : "xserver_name",
"alias" : "xserver_name",
"sql-data-type" : "VARCHAR",
"column-value-selection-strategy" : "SelectColumnValue"
},
"field" : {
"type" : "Data",
"name" : "xserver_name",
"neo4j-data-type" : "String",
"is-array" : false
}
}, {
"column" : {
"type" : "SimpleColumn",
"role" : "Data",
"table" : "spt_fallback_db",
"schema" : "master.dbo",
"name" : "name",
"alias" : "name",
"sql-data-type" : "VARCHAR",
"column-value-selection-strategy" : "SelectColumnValue"
},
"field" : {
"type" : "Data",
"name" : "name",
"neo4j-data-type" : "String",
"is-array" : false
}
}, {
"column" : {
"type" : "SimpleColumn",
"role" : "Literal",
"table" : "spt_fallback_db",
"schema" : "master.dbo",
"name" : "SptFallbackDb",
"alias" : "_NODE_LABEL_",
"sql-data-type" : "VARCHAR",
"column-value-selection-strategy" : "SelectColumnValue"
},
"field" : {
"type" : "Label"
}
} ]
}, {
"name" : "NODE_master.dbo.sptmonitor_b32d70ba-0f1b-4b55-8596-1e6170431d29",
"schema" : "master.dbo",
"graph-object-type" : "Node",
"sql" : "SELECT \"master\".\"dbo\".\"spt_monitor\".\"connections\" AS \"connections\", \"master\".\"dbo\".\"spt_monitor\".\"io_busy\" AS \"io_busy\", \"master\".\"dbo\".\"spt_monitor\".\"total_errors\" AS \"total_errors\", \"master\".\"dbo\".\"spt_monitor\".\"pack_sent\" AS \"pack_sent\", \"master\".\"dbo\".\"spt_monitor\".\"pack_received\" AS \"pack_received\", \"master\".\"dbo\".\"spt_monitor\".\"idle\" AS \"idle\", \"master\".\"dbo\".\"spt_monitor\".\"total_read\" AS \"total_read\", \"master\".\"dbo\".\"spt_monitor\".\"pack_errors\" AS \"pack_errors\", \"master\".\"dbo\".\"spt_monitor\".\"cpu_busy\" AS \"cpu_busy\", \"master\".\"dbo\".\"spt_monitor\".\"total_write\" AS \"total_write\", \"master\".\"dbo\".\"spt_monitor\".\"lastrun\" AS \"lastrun\", 'SptMonitor' AS \"_NODE_LABEL_\" FROM \"master\".\"dbo\".\"spt_monitor\"",
"mappings" : [ {
"column" : {
"type" : "SimpleColumn",
"role" : "PrimaryKey",
"table" : "spt_monitor",
"schema" : "master.dbo",
"name" : "_ROW_INDEX_",
"alias" : "_ROW_INDEX_",
"sql-data-type" : "INTEGER",
"column-value-selection-strategy" : "SelectRowIndex"
},
"field" : {
"type" : "Id",
"name" : "",
"id-space" : "master.dbo.spt_monitor"
}
}, {
"column" : {
"type" : "SimpleColumn",
"role" : "Data",
"table" : "spt_monitor",
"schema" : "master.dbo",
"name" : "connections",
"alias" : "connections",
"sql-data-type" : "INTEGER",
"column-value-selection-strategy" : "SelectColumnValue"
},
"field" : {
"type" : "Data",
"name" : "connections",
"neo4j-data-type" : "Long",
"is-array" : false
}
}, {
"column" : {
"type" : "SimpleColumn",
"role" : "Data",
"table" : "spt_monitor",
"schema" : "master.dbo",
"name" : "io_busy",
"alias" : "io_busy",
"sql-data-type" : "INTEGER",
"column-value-selection-strategy" : "SelectColumnValue"
},
"field" : {
"type" : "Data",
"name" : "io_busy",
"neo4j-data-type" : "Long",
"is-array" : false
}
}, {
"column" : {
"type" : "SimpleColumn",
"role" : "Data",
"table" : "spt_monitor",
"schema" : "master.dbo",
"name" : "total_errors",
"alias" : "total_errors",
"sql-data-type" : "INTEGER",
"column-value-selection-strategy" : "SelectColumnValue"
},
"field" : {
"type" : "Data",
"name" : "total_errors",
"neo4j-data-type" : "Long",
"is-array" : false
}
}, {
"column" : {
"type" : "SimpleColumn",
"role" : "Data",
"table" : "spt_monitor",
"schema" : "master.dbo",
"name" : "pack_sent",
"alias" : "pack_sent",
"sql-data-type" : "INTEGER",
"column-value-selection-strategy" : "SelectColumnValue"
},
"field" : {
"type" : "Data",
"name" : "pack_sent",
"neo4j-data-type" : "Long",
"is-array" : false
}
}, {
"column" : {
"type" : "SimpleColumn",
"role" : "Data",
"table" : "spt_monitor",
"schema" : "master.dbo",
"name" : "pack_received",
"alias" : "pack_received",
"sql-data-type" : "INTEGER",
"column-value-selection-strategy" : "SelectColumnValue"
},
"field" : {
"type" : "Data",
"name" : "pack_received",
"neo4j-data-type" : "Long",
"is-array" : false
}
}, {
"column" : {
"type" : "SimpleColumn",
"role" : "Data",
"table" : "spt_monitor",
"schema" : "master.dbo",
"name" : "idle",
"alias" : "idle",
"sql-data-type" : "INTEGER",
"column-value-selection-strategy" : "SelectColumnValue"
},
"field" : {
"type" : "Data",
"name" : "idle",
"neo4j-data-type" : "Long",
"is-array" : false
}
}, {
"column" : {
"type" : "SimpleColumn",
"role" : "Data",
"table" : "spt_monitor",
"schema" : "master.dbo",
"name" : "total_read",
"alias" : "total_read",
"sql-data-type" : "INTEGER",
"column-value-selection-strategy" : "SelectColumnValue"
},
"field" : {
"type" : "Data",
"name" : "total_read",
"neo4j-data-type" : "Long",
"is-array" : false
}
}, {
"column" : {
"type" : "SimpleColumn",
"role" : "Data",
"table" : "spt_monitor",
"schema" : "master.dbo",
"name" : "pack_errors",
"alias" : "pack_errors",
"sql-data-type" : "INTEGER",
"column-value-selection-strategy" : "SelectColumnValue"
},
"field" : {
"type" : "Data",
"name" : "pack_errors",
"neo4j-data-type" : "Long",
"is-array" : false
}
}, {
"column" : {
"type" : "SimpleColumn",
"role" : "Data",
"table" : "spt_monitor",
"schema" : "master.dbo",
"name" : "cpu_busy",
"alias" : "cpu_busy",
"sql-data-type" : "INTEGER",
"column-value-selection-strategy" : "SelectColumnValue"
},
"field" : {
"type" : "Data",
"name" : "cpu_busy",
"neo4j-data-type" : "Long",
"is-array" : false
}
}, {
"column" : {
"type" : "SimpleColumn",
"role" : "Data",
"table" : "spt_monitor",
"schema" : "master.dbo",
"name" : "total_write",
"alias" : "total_write",
"sql-data-type" : "INTEGER",
"column-value-selection-strategy" : "SelectColumnValue"
},
"field" : {
"type" : "Data",
"name" : "total_write",
"neo4j-data-type" : "Long",
"is-array" : false
}
}, {
"column" : {
"type" : "SimpleColumn",
"role" : "Data",
"table" : "spt_monitor",
"schema" : "master.dbo",
"name" : "lastrun",
"alias" : "lastrun",
"sql-data-type" : "TIMESTAMP",
"column-value-selection-strategy" : "SelectColumnValue"
},
"field" : {
"type" : "Data",
"name" : "lastrun",
"neo4j-data-type" : "String",
"is-array" : false
}
}, {
"column" : {
"type" : "SimpleColumn",
"role" : "Literal",
"table" : "spt_monitor",
"schema" : "master.dbo",
"name" : "SptMonitor",
"alias" : "_NODE_LABEL_",
"sql-data-type" : "VARCHAR",
"column-value-selection-strategy" : "SelectColumnValue"
},
"field" : {
"type" : "Label"
}
} ]
}, {
"name" : "NODE_master.dbo.sptfallbackdev_551e6f56-9757-481b-84a0-7b62f55cbc18",
"schema" : "master.dbo",
"graph-object-type" : "Node",
"sql" : "SELECT \"master\".\"dbo\".\"spt_fallback_dev\".\"phyname\" AS \"phyname\", \"master\".\"dbo\".\"spt_fallback_dev\".\"xdttm_last_ins_upd\" AS \"xdttm_last_ins_upd\", \"master\".\"dbo\".\"spt_fallback_dev\".\"xdttm_ins\" AS \"xdttm_ins\", \"master\".\"dbo\".\"spt_fallback_dev\".\"high\" AS \"high\", \"master\".\"dbo\".\"spt_fallback_dev\".\"name\" AS \"name\", \"master\".\"dbo\".\"spt_fallback_dev\".\"status\" AS \"status\", \"master\".\"dbo\".\"spt_fallback_dev\".\"low\" AS \"low\", \"master\".\"dbo\".\"spt_fallback_dev\".\"xfallback_drive\" AS \"xfallback_drive\", \"master\".\"dbo\".\"spt_fallback_dev\".\"xserver_name\" AS \"xserver_name\", \"master\".\"dbo\".\"spt_fallback_dev\".\"xfallback_low\" AS \"xfallback_low\", 'SptFallbackDev' AS \"_NODE_LABEL_\" FROM \"master\".\"dbo\".\"spt_fallback_dev\"",
"mappings" : [ {
"column" : {
"type" : "SimpleColumn",
"role" : "PrimaryKey",
"table" : "spt_fallback_dev",
"schema" : "master.dbo",
"name" : "_ROW_INDEX_",
"alias" : "_ROW_INDEX_",
"sql-data-type" : "INTEGER",
"column-value-selection-strategy" : "SelectRowIndex"
},
"field" : {
"type" : "Id",
"name" : "",
"id-space" : "master.dbo.spt_fallback_dev"
}
}, {
"column" : {
"type" : "SimpleColumn",
"role" : "Data",
"table" : "spt_fallback_dev",
"schema" : "master.dbo",
"name" : "phyname",
"alias" : "phyname",
"sql-data-type" : "VARCHAR",
"column-value-selection-strategy" : "SelectColumnValue"
},
"field" : {
"type" : "Data",
"name" : "phyname",
"neo4j-data-type" : "String",
"is-array" : false
}
}, {
"column" : {
"type" : "SimpleColumn",
"role" : "Data",
"table" : "spt_fallback_dev",
"schema" : "master.dbo",
"name" : "xdttm_last_ins_upd",
"alias" : "xdttm_last_ins_upd",
"sql-data-type" : "TIMESTAMP",
"column-value-selection-strategy" : "SelectColumnValue"
},
"field" : {
"type" : "Data",
"name" : "xdttm_last_ins_upd",
"neo4j-data-type" : "String",
"is-array" : false
}
}, {
"column" : {
"type" : "SimpleColumn",
"role" : "Data",
"table" : "spt_fallback_dev",
"schema" : "master.dbo",
"name" : "xdttm_ins",
"alias" : "xdttm_ins",
"sql-data-type" : "TIMESTAMP",
"column-value-selection-strategy" : "SelectColumnValue"
},
"field" : {
"type" : "Data",
"name" : "xdttm_ins",
"neo4j-data-type" : "String",
"is-array" : false
}
}, {
"column" : {
"type" : "SimpleColumn",
"role" : "Data",
"table" : "spt_fallback_dev",
"schema" : "master.dbo",
"name" : "high",
"alias" : "high",
"sql-data-type" : "INTEGER",
"column-value-selection-strategy" : "SelectColumnValue"
},
"field" : {
"type" : "Data",
"name" : "high",
"neo4j-data-type" : "Long",
"is-array" : false
}
}, {
"column" : {
"type" : "SimpleColumn",
"role" : "Data",
"table" : "spt_fallback_dev",
"schema" : "master.dbo",
"name" : "name",
"alias" : "name",
"sql-data-type" : "VARCHAR",
"column-value-selection-strategy" : "SelectColumnValue"
},
"field" : {
"type" : "Data",
"name" : "name",
"neo4j-data-type" : "String",
"is-array" : false
}
}, {
"column" : {
"type" : "SimpleColumn",
"role" : "Data",
"table" : "spt_fallback_dev",
"schema" : "master.dbo",
"name" : "status",
"alias" : "status",
"sql-data-type" : "SMALLINT",
"column-value-selection-strategy" : "SelectColumnValue"
},
"field" : {
"type" : "Data",
"name" : "status",
"neo4j-data-type" : "Long",
"is-array" : false
}
}, {
"column" : {
"type" : "SimpleColumn",
"role" : "Data",
"table" : "spt_fallback_dev",
"schema" : "master.dbo",
"name" : "low",
"alias" : "low",
"sql-data-type" : "INTEGER",
"column-value-selection-strategy" : "SelectColumnValue"
},
"field" : {
"type" : "Data",
"name" : "low",
"neo4j-data-type" : "Long",
"is-array" : false
}
}, {
"column" : {
"type" : "SimpleColumn",
"role" : "Data",
"table" : "spt_fallback_dev",
"schema" : "master.dbo",
"name" : "xfallback_drive",
"alias" : "xfallback_drive",
"sql-data-type" : "CHAR",
"column-value-selection-strategy" : "SelectColumnValue"
},
"field" : {
"type" : "Data",
"name" : "xfallback_drive",
"neo4j-data-type" : "String",
"is-array" : false
}
}, {
"column" : {
"type" : "SimpleColumn",
"role" : "Data",
"table" : "spt_fallback_dev",
"schema" : "master.dbo",
"name" : "xserver_name",
"alias" : "xserver_name",
"sql-data-type" : "VARCHAR",
"column-value-selection-strategy" : "SelectColumnValue"
},
"field" : {
"type" : "Data",
"name" : "xserver_name",
"neo4j-data-type" : "String",
"is-array" : false
}
}, {
"column" : {
"type" : "SimpleColumn",
"role" : "Data",
"table" : "spt_fallback_dev",
"schema" : "master.dbo",
"name" : "xfallback_low",
"alias" : "xfallback_low",
"sql-data-type" : "INTEGER",
"column-value-selection-strategy" : "SelectColumnValue"
},
"field" : {
"type" : "Data",
"name" : "xfallback_low",
"neo4j-data-type" : "Long",
"is-array" : false
}
}, {
"column" : {
"type" : "SimpleColumn",
"role" : "Literal",
"table" : "spt_fallback_dev",
"schema" : "master.dbo",
"name" : "SptFallbackDev",
"alias" : "_NODE_LABEL_",
"sql-data-type" : "VARCHAR",
"column-value-selection-strategy" : "SelectColumnValue"
},
"field" : {
"type" : "Label"
}
} ]
}, {
"name" : "REL_CUSTPRMP_654575fc-c52d-464f-a818-530de8cf7562",
"schema" : "master.dbo",
"graph-object-type" : "Relationship",
"sql" : "SELECT \"master\".\"dbo\".\"CUSTEXTP\".\"CUSTNUM\" AS \"CUSTNUM\", 'CUSTPRMP' AS \"_RELATIONSHIP_TYPE_\" FROM \"master\".\"dbo\".\"CUSTEXTP\"",
"mappings" : [ {
"column" : {
"type" : "SimpleColumn",
"role" : "PrimaryKey",
"table" : "CUSTEXTP",
"schema" : "master.dbo",
"name" : "_ROW_INDEX_",
"alias" : "_ROW_INDEX_",
"sql-data-type" : "INTEGER",
"column-value-selection-strategy" : "SelectRowIndex"
},
"field" : {
"type" : "StartId",
"id-space" : "master.dbo.custextp"
}
}, {
"column" : {
"type" : "CompositeColumn",
"table" : "CUSTEXTP",
"schema" : "master.dbo",
"role" : "ForeignKey",
"columns" : [ {
"type" : "JoinColumn",
"role" : "Data",
"table" : "CUSTEXTP",
"schema" : "master.dbo",
"name" : "CUSTNUM",
"alias" : "CUSTNUM",
"sql-data-type" : "DECIMAL",
"column-value-selection-strategy" : "SelectColumnValue",
"referenced-column" : {
"type" : "SimpleColumn",
"role" : "Data",
"table" : "CUSTPRMP",
"schema" : "master.dbo",
"name" : "CUSTNUM",
"alias" : "CUSTNUM",
"sql-data-type" : "DECIMAL",
"column-value-selection-strategy" : "SelectColumnValue"
}
} ]
},
"field" : {
"type" : "EndId",
"id-space" : "master.dbo.custprmp"
}
}, {
"column" : {
"type" : "SimpleColumn",
"role" : "Literal",
"table" : "CUSTEXTP",
"schema" : "master.dbo",
"name" : "CUSTPRMP",
"alias" : "_RELATIONSHIP_TYPE_",
"sql-data-type" : "VARCHAR",
"column-value-selection-strategy" : "SelectColumnValue"
},
"field" : {
"type" : "RelationshipType"
}
} ]
} ]
Lastly, below, you can see the screenshot from the GUI application that showcases the fact that the 'Next' button is disabled:
Has anyone experienced this problem before? If so, are there any known workarounds or fixes?
Thanks!
1 ACCEPTED SOLUTION
NODES 2022, Neo4j Online Education Summit
All the sessions of the conference are now available online
