Import data from Excel and \ or SQL Server

Are there any docs or examples on now to import from Excel or SQL Server?

What other options are there for importing data?

Thank you

@georgep you can use Fauna Data Manager FDM. What kind of workloads are you trying to import ?

Hi Jay,

I “Really” appreciate the fast responses.

I tried to install FDM by coping the zip to here:
C:\faunadb\fdm-1.14

then I ran this command from Windows Powershell:
./fdm

but I got this error:

Error: A JNI error has occurred, please check your installation and try again
Exception in thread “main” java.lang.UnsupportedClassVersionError: com/fauna/fdm/Main has been compiled by a more recent version of the Java Runtime (class file version 55.0), this version of the Java Runtime only recognizes class file versions up to 52.0
at java.lang.ClassLoader.defineClass1(Native Method)
at java.lang.ClassLoader.defineClass(ClassLoader.java:763)
at java.security.SecureClassLoader.defineClass(SecureClassLoader.java:142)
at java.net.URLClassLoader.defineClass(URLClassLoader.java:468)
at java.net.URLClassLoader.access$100(URLClassLoader.java:74)
at java.net.URLClassLoader$1.run(URLClassLoader.java:369)
at java.net.URLClassLoader$1.run(URLClassLoader.java:363)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:362)
at java.lang.ClassLoader.loadClass(ClassLoader.java:424)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:349)
at java.lang.ClassLoader.loadClass(ClassLoader.java:357)
at sun.launcher.Laun

and this is the java version I have: 1.8.0_261

  1. Workloads:
    For a proof of concept i want to import about 1200 companies, 150 categories, and about 4000 many to many relationships between company and category.

but later companies may increase to 30-40k categories to 300 and the M2M relationships… a lot more…

and if all goes well, all of this will increase much more agian.

@georgep couple of things before you start with FDM as it is still in Preview mode plus you seem to have a Windows shop :slight_smile:

  1. Please refer this limitations section.

While the Fauna Data Manager works on Windows, only limited testing has been done on that platform. You may experience unexpected platform-specific issues. We certainly plan to expand our Windows testing for the Fauna Data Manager for future releases.

  1. FDM needs Java 11 and above.

One more thing, FDM does not support relationships that you create in GraphQL.

the docs said Java 11 or later, so I installed Java 13 and still get the following error:

Error: A JNI error has occurred, please check your installation and try again
Exception in thread “main” java.lang.UnsupportedClassVersionError: com/fauna/fdm/Main has been compiled by a more recent version of the Java Runtime (class file version 55.0), this version of the Java Runtime only recognizes class file versions up to 52.0
at java.lang.ClassLoader.defineClass1(Native Method)
at java.lang.ClassLoader.defineClass(ClassLoader.java:763)
at java.security.SecureClassLoader.defineClass(SecureClassLoader.java:142)
at java.net.URLClassLoader.defineClass(URLClassLoader.java:468)
at java.net.URLClassLoader.access$100(URLClassLoader.java:74)
at java.net.URLClassLoader$1.run(URLClassLoader.java:369)
at java.net.URLClassLoader$1.run(URLClassLoader.java:363)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:362)
at java.lang.ClassLoader.loadClass(ClassLoader.java:424)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:349)
at java.lang.ClassLoader.loadClass(ClassLoader.java:357)
at sun.launcher.LauncherHelper.checkAndLoadMain(LauncherHelper.java:495

May be you have multiple versions of Java and FDM is using the old one ? Did you explicitly setup JAVA_HOME environment variable ?

This is my environment variable:
image

should I change it from
1.8.0.15
to
1.8.0_261
or
1.8.0.261
or
1.8.0.26

It should be to the path where you have Java 13 installed.

Hmmm. That path references this which was installed by MS here in March:

@georgep that is Java 8 ( naming convention then was 1.8). You can install later versions of Java11 or Java13. I think the latest Java version is Java15.