October 17, 2024 at 2:14 pm
Hi we built a gateway from sql server to netsuite using an oracle competitor's odbc driver.
once it was standing we noticed 111 columns missing in the linked server views for i believe just "salesinvoiced", customers and items alone. we have nsaw but its on a different netsuite instance and i believe out of scope of this question. as far as i know most or all of the missing columns are standard not custom and i can query them on netsuite using suite ql. according to the very first rep we spoke to at oracle, if you can query a field in suite ql on netsuite, you can get it thru an odbc driver.
I've heard a few things thus far that dont add up so im asking the community if the've had a similar experience..
one thing that strikes me is that #3 may be illegal (monopoly kind of thing) if it actually blocks (indirectly) the competitor products from seeing a huge percentage of fields.
October 18, 2024 at 3:10 pm
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
November 13, 2024 at 7:18 pm
This was removed by the editor as SPAM
November 14, 2024 at 9:20 pm
i think somewhat consistent comments are starting to come in from CData (the competitor) and Oracle Netsuite.
CData clarified that their odbc driver taps into netsuite's suite ql API. and there are restrictions on what will show based on a sampling they take of i think the 1st 1000 rows. i believe (dont quote me) if all 1000 have a null in a specific column, it is discarded but i believe there is a way to sample more. ive sent them a question asking "if we start using such columns or introduce non null custom columns will they automatically show without a re install". and we did introduce one non null value into a customer column previously missing from cdata's driver. its currently on one customer only. we'll see if it spontaneously shows up in the odbc world.
netsuite echoed the latter about the API labeling the api as REST too and shared additional links specific to CData on this subject.
im starting to think there really arent views per se in netsuite and its still unclear what NetSuite2.com is. i'm starting to think that oauth2 and other security approaches arent the culprits here in hiding fields. there is more to learn. i am concerned that if we run some kind of conversion on netsuite where all values of a given column are temporarily nulled, that our etl will abort as it references columns that at that time wont be returned. this feels somewhat messy.
November 15, 2024 at 2:13 pm
i can confirm today that CData's odbc driver does indeed show previously hidden netsuite fields once they start getting used (ie arent all null).
There is what sounds like a choice that is dependent on whether "metadata caching" is turned on (which im getting clarification on) and then 1) a 2hr interval during which no connections have been made to netsuite, or 2) issuing a reset schema cache call.
Im not sure and am checking but suspect restarting their service would update the metadata as well.
I'm told this will happen for newly added / used custom fields as well.
I believe for any field, roles could impact whether a column shows anyway.
November 17, 2024 at 3:04 am
BUY REAL PASSPORTS,VISA,DRIVERS LICENSE,GMAT,IELTS,PLAB 1&2 CERTIFICATES, BUY IELTS,GRE,TOEIC,TOEFL,PET, FCE,CAE, CPE, BEC,YLE, KET,BULA TS,ILEC, ICFEWhatsApp:+1 (951) 480-4136
Telegram: @Approvedocs356days
Website: https://approvedocs.com/
Email: approvedocuments237@gmail.com
buy real passport, genuine passport for sale, fake passport for sale online, buy real and fake passport online, buy real genuine fake passport online, purchase passport online, buy legal american passport, purchase fake US passport online, purchase fake EU passport,
Buy Second Passport Buy Citizenship IELTS/TOEFL IDP, GMAT, ESOL,NE BOSH, DIPLOMAS,ETC
Buy Driver’s License | New legal driving license?
BUY QUALITY FAKE/REAL Passport-USA ,UK , GERMANY
We are the world number one independent group of specialize IT professionals and database technicians base in the USA, we are specialized in the making of genuine passport SSN, ID card, Birth Certificate, Visa, PR, Diplomas and many other documents of very unique quality. We have produced passports, Drivers license, SSN, ID card, Birth certificates, diplomas and other documents for over 150 countries.
We produce genuine registered documents which are legally used and we also produce Fake or Novelty documents which are just use for camouflage and can not be use legally, these types of document are not important so we produce on high demand and order We also work with agents from top embassies within the world who have all our clients information processed from within and have everything authenticated in the supposed database system. So everything we do regarding the production of a genuine passport, SSN, ID card, Birth Certificate, Visa, PR, Diplomas and many other documents are genuine and all the real documents that can be legally used. With over 17 years of service with our expertise in producing genuine passport, SSN, ID card, Birth Certificate, Visa, PR, Diplomas and many other documents, over 23 millions of our produced documents are circulating the world also with people facing problems to cross international boundaries and also help some to get jobs both nationally and internationally and for complicated cases we have immigration lawyers who help our clients if they have any difficulties. We have produce documents for many Celebrities and Politicians and top Government officials from different continents.
We quite know the risk in carrying or using a fake document that is why we invest our technologies, professionalism and skills to put in a company so as to aid people who find it difficult to have a particular document
We process passports for Canada, USA, Germany, UK, Belgium, EU countries, South Africa and other parts of the world. Feel free to contact us anytime you wish. We have Asian Brothers to sort any documentation issue you may have. Whether Genuine or Novelty Document
BUY REGISTERED PASSPORTS AND DRIVERS LICENSES
Identity cards, resident permits, visas::
Buy IELTS/TOEFL IDP, GMAT, ESOL,NE BOSH, DIPLOMAS,ETC
How do we do it? trade secret! but we can assure you that you’ll have no problems using our documents. Information on how to send us the data needed(scanned signature, biometric image etc) will be given after receiving your order.
We also have counterfeit banknotes(Eur, cad, aid, GB, used etc) for sale. Most recent designs and the quality of our banknotes are rare to find. We ship internationally with no hassles. ID cards,buy passport, fake passport, Driver’s License, Banknotes,OUR KEY WORDS
buy fake documents online, where can i buy fake passport, buy real fake passports, buy real and fake passport online, fake passport online maker, genuine passports for sale, purchase passport online, buy UK driving licence online, buy real driving license UK, buy EU driving licence without test, quickest way to get driving licence, fake Bulgarian driving licence, buy real driver’s license, buy fake UK driving licence, fake uk driving licence, buy genuine driving licence, buy driving licence, fake drivers license online, fake driving licence, fake driver’s license, quickest and easiest way to get bike licence, fastest way to get a full UK driving licence, buy fake id online, scan-able fake id, fake id maker online, birth certificate online, apply for birth certificate online, I’ve lost my birth certificate, birth certificate prices, full birth certificate uk, how do i get a copy of my birth certificate UK, instant bachelor’s degree, buy degree from any university, buy a degree uk, verifiable degree, fake degree from real university, fake college diploma maker, buy a degree from a real university, fake diploma high school, fake diplomas that look real, fake certificates online, fake certificate maker, best fake money, where can i buy counterfeit money, buy fake notes online, buy undetectable counterfeit money, buy counterfeit money, high quality counterfeit money for sale, buy fake money that looks real.
-IDs Scan-yes…
-HOLOGRAMS: IDENTICAL
-BAR CODES: IDS SCAN
-UV: YES
-Passports
FAKE IDS WITH FAST SHIPPING – EMAIL SUPPORT
Fake ID’s Over state drivers license cards and State ID, stamps, Visa, school Diplomas and other products for a number of countries like:USA, Australia, Belgium,Brazil, Canada, Italy,Finland, France,Germany, Israel, Mexico, Netherlands, South Africa,Spain, United Kingdom+1 (951) 480-4136
Telegram: @Approvedocs356days
REGISTERED AND UNREGISTERED BRITISH PASSPORT.
REGISTERED AND UNREGISTERED CANADIAN PASSPORT.
REGISTERED AND UNREGISTERED FRENCH PASSPORT.
REGISTERED AND UNREGISTERED AMERICAN PASSPORT.
REGISTERED AND UNREGISTERED RUSSIAN PASSPORT.
REGISTERED AND UNREGISTERED JAPANESE PASSPORT.
REGISTERED AND UNREGISTERED CHINESE PASSPORT.
Buy Registered and unregistered USA(United States) passports,
Buy Registered and unregistered Australian passports,
Buy Registered and unregistered Belgium passports,
Buy Registered and unregistered Brazilian(Brazil) passports,
Buy Registered and unregistered Canadian(Canada) passports,
Buy Registered and unregistered Finnish(Finland) passports,
Buy Registered and unregistered French(France) passports,
Buy Registered and unregistered German(Germany) passports,
Buy Registered and unregistered Dutch(Netherlands/Holland) passports,
Buy Registered and unregistered Israel passports,
Buy Registered and unregistered UK(United Kingdom) passports,
Buy Registered and unregistered Spanish(Spain) passports,
Buy Registered and unregistered Mexican(Mexico) passports,
Buy Registered and unregistered South African passports.
Buy Registered and unregistered Australian driver licenses,
Buy Registered and unregistered Canadian driver licenses,
Buy Registered and unregistered French(France) driver licenses,
Buy Registered and unregistered Dutch(Netherlands/Holland) driving licenses,
Buy Registered and unregistered German(Germany) driving licenses,
Buy Registered and unregistered UK(United Kingdom) driving licenses,
Buy Registered and unregistered Diplomatic passports,
IELTS certificate,
Express Canadian citizenship documents
Verified id cards
Passport registered
Canada ID Cards
United States ID Cards
Student ID Cards
International Cards
Private Cards
Adoption Certificates
Baptism Certificates
Birth Certificates
Death Certificates
Divorce Certificates
Marriage Certificates
Custom Certificates
High School Diplomas
G.E.D. Diplomas
Home School Diplomas
College Degrees
University Degrees
Trade Skill Certificates
Social Security We have a group of IT professionals and data base technicians operating worldwide with practical experience in the creation of outstanding documents, We issue database registered documents that are registered into the system and bypass all police and custom checkpoints,
Validate SSN Number Delivery is by one of a following,WhatsApp:+1 (951) 480-4136
Telegram: @Approvedocs356days
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply