Activity for ServiceNow Data Mart Loader
-
michael ocasio posted a comment on discussion General Discussion
It seems not mapping correctly when Oracle thin driver is used fro replicating the data... whereas for PostGreSLQ and MySQL it works fine......
-
I using a CENTOS image from AWS connected to a RDS Service (Oracle)...... In the image I install SQL Plus and I was able to meet the requirements..... which to create a table...... I have installed the Oracle jdbc 1.8.02...... I am able to interpret a java application.... Now im trying to to a make a connection to the RDS Service but I haven't find out the correct syntax.... which brings me to line in the profile line datamart.url=jdbc:mysql://localhost/sndm ....... which I dont know which driver...
-
Can I used the latest version of Oracle jdbc to implement the driver for this app?
-
Giles Lewis posted a comment on discussion General Discussion
The SOAP Web Services API always returns datetime fields in GMT since this is how they are stored internally in ServiceNow. To ensure consistency and prevent possible bugs you should set the timezone to GMT for the Web Services user account in ServiceNow (sys_user). In your SQL database you should store your datetime fields in GMT. Use a database function to convert them to local time. The method varies by the type of database. For MySQL use "SET TIME_ZONE". For Oracle use "ALTER SESSION".
-
Anonymous posted a comment on discussion General Discussion
Hi we have a problem. All of our date fields are being changed by +5 hours (GMT time?). Wierd issue and I don't see this documented anywhere. Thanks!!
-
Anonymous posted a comment on discussion General Discussion
I am using Helsinki version, and I am getting the same error, appreciate help from anyone. please? C:\Users\Gil Sabado\Desktop\snow-link>java -jar servicenow-sql-pump.jar -p datapump.properties -f load_location.txt INFO DataPump.Pumper propfile=datapump.properties INFO DataPump.DatabaseWriter database=jdbc:oracle:thin:@localhost:1521:xe user=snow INFO DataPump.DatabaseWriter alter session set nls_length_semantics = 'CHAR' INFO DataPump.DatabaseWriter alter session set nls_date_format = 'YYYY-MM-DD'...
-
This version of SNDML is no longer supported. Please download 2.6.5 from https:/...
-
Anonymous posted a comment on discussion General Discussion
Could you help me with the below error : Its able to create the table in the local...
-
Home
-
Home
-
This code is really old (more than 2 years) and the diagnostic messages are not very...
-
Anonymous posted a comment on discussion General Discussion
Have the same issue this code doesnt even work on the Demo sanbox env in service...
-
Anonymous posted a comment on discussion General Discussion
I tried folllowing the "QuickStart" instructions - using the demo instance and the...
-
Anonymous posted a comment on discussion General Discussion
Could it be linked to ServiceNow instances that are running Fuji? D.
-
Anonymous posted a comment on discussion General Discussion
Hello, I configured datapump refresh jobs for insert and updates on Service now tables...
-
Anonymous posted a comment on discussion General Discussion
Looks very similar to my issue...Haven't identified the problem yet. java -jar servicenow-sql-pump.jar...
-
Anonymous posted a comment on discussion General Discussion
Can anyone advise what is the correct jdbc connection string for a MySQL db or whether...
-
Anonymous posted a comment on discussion General Discussion
Hello, I am running refresh job every 24 hours to pull incident data from service...
-
Anonymous posted a comment on discussion General Discussion
also, as a protip to all, it appears that the database name and user account name...
-
Anonymous posted a comment on discussion General Discussion
solved my own problem, turns out my JDBC string was wrong
-
Anonymous posted a comment on discussion General Discussion
Hi, I tried running the example from the Quick Start against my instance and I am...
-
Anonymous posted a comment on discussion General Discussion
This application has no UI and it uses no port. It runs from a command line. It connects...
-
Anonymous posted a comment on discussion General Discussion
Hi, By default the port is 80. Is there any way to change it (to 50000 for instance)?...
-
Anonymous posted a comment on discussion General Discussion
Hi, I am trying to use this library and have setup SN Sandbox instance but can;t...
-
Anonymous posted a comment on discussion General Discussion
Hi..I am trying to configure and load the table.I am getting teh error..Could you...
-
Anonymous posted a comment on discussion General Discussion
Ran the latest jar and cmn_location was sucessfully created in Oracle but data was...
-
We have never synchronized a table this large. But it should be possible. The key...
-
Anonymous modified a comment on discussion General Discussion
Hello We are currently using the Service Now ODBC driver (http://wiki.servicenow.com/index.php?title=ODBC_Driver)...
-
Anonymous posted a comment on discussion General Discussion
Hello We are currently using the Service Now ODBC driver (http://wiki.servicenow.com/index.php?title=ODBC_Driver)...
-
Quick Start
-
datapump.properties
-
datapump.properties
-
I think the correct syntax is pumper.signal_file=k:\signal.txt Please try this change....
-
Anonymous posted a comment on discussion General Discussion
datapump.properties servicenow.url=https://.service-now.com/ servicenow.username=username...
-
Can you share the content of your datapump.properties and ldtasks.txt file? Just...
-
Anonymous posted a comment on discussion General Discussion
i tried adding the pumper.signal file but that did not work for me .
-
Did you specify pumper.signal file in your properties file? Someone else reported...
-
Anonymous posted a comment on discussion General Discussion
i am getting the following error can you help K:\SNapps>java -cp k:\SNapps\ -jar...
-
GUI
-
Minimal documentation is here: https://sourceforge.net/p/servicenowpump/wiki/GUI/...
-
GUI
-
GUI
-
GUI
-
GUI
-
GUI
-
GUI
-
GUI
-
Home
-
Command Line Options
-
Anonymous posted a comment on discussion General Discussion
Is there any documentation on how to use the GUI mode?