Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
Don’t miss your chance to meet our SuiteGurus—NetSuite Support professionals and subject matter experts with extensive experience in select product areas, including OneWorld, Advanced & Basic Accounting, Supply Chain Management, Receivables & Payables, CRM, Account Administration, and the SuiteCloud Platform. Full Conference attendees can prebook exclusive 30-minute one-on-one sessions for your product questions.
Spots are limited! Register through your Agenda Builder and find SuiteGuru under Agenda Enhancements.
ODBC Data Types
Hi,
I'm just wondering if anyone else has come across any data type issues when using ODBC (driver version 7.02.00.54).
The issue that we're having is that none of the data types are being recognised correctly across any of the applications that we use which use the system DSN created during the ODBC setup process.
All fields are either coming through as either nvarchar(4000) or float and nothing matches the data types specified in the connect schema documentation.
Is there a way to configure the codepages or data types of the ODBC connection itself as no amount of tweaking source/input/output properties in applications such as SSIS will change them and we are presently having to convert all data at the time of extraction from the odbc source which is impacting performance and unnecessarily complicating our ETL processes.